Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “guineas” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

325 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
guineas83675(None) 
guinea737611guinea_
eupneas935232eupneas
gainers84214592gainers
gluiness937362gluiness
gringas938042gringas
guiders94111112guiders
guides84118282guide_s
guiles73919282guile_s
guises74216312guise_s
gunnels8358562gunnels
gunners83111732gunners
gurnets84010792gurnets
gurneys11406462gurneys
quinelas1744932quinelas
quinoas16337872quinoas
quintas163611712quintas
ruiners74213022ruiners
tineas64616482_tineas
usneas638332_usneas
aliners74717723aliners
alines65735223aline_s
amines84727983amine_s
apneas83211383_apneas
azines155517073azine_s
beguines11127213beguine_s
biners85023633_biners
bines76946793_bine_s
briners94315633briners
brines85028853brine_s
bubingas1352803bubingas
bunas75126573bu_n_as
bunyas11359433bu_nyas
burners94115673burners
burnets93813263burnets
business102110693business
chinas115119403chin_as
chines115029173chine_s
cineast9310523_cineast
cinemas1138043_cinemas
cines75239683_cine_s
clines84926043cline_s
coiners93620753coiners
corneas94717003corneas
cuneal8611513cu_neal
cunners93913473cunners
diners75525953_diners
dines66449153_dine_s
dueness82310123dueness
duennas834143duennas
duikers12369383duikers
dulcineas1242433dulcineas
dulness8307983dulness
dunes65332173du_ne_s
dunness8298983dunness
dwines105013103dwine_s
equines161811593equine_s
eupnea835033eupnea_
eupnoeas1042803eupnoeas
exines135715803exine_s
fincas113512073_fincas
fines86644263_fine_s
fulness10248963fulness
funnels10348173funnels
gained84617463gaine_d
gainer74117493gaine_r
gainless9117403gainless
gains65729513gain__s
gainsay1144033gainsay
gainsays1243503gainsays
gaiters83516543gaiters
galeas74618513g_aleas
galenas83310343galenas
gamines103618463gamine_s
gaminess112911063gaminess
ganefs10489203g_anefs
ganevs10456913g_anevs
ganjas14149113g_anjas
gannets83811443gannets
garners83815983garners
garnets84115403garnets
gaudiness1136253gaudiness
gauziness1934613gauziness
gayness1136843gayness
geishas1135073geishas
genes65133093g_ene_s
genets75716663g_enets
genevas1185253g_enevas
genies75324943genie_s
genoas74013623g_enoas
gibers95114663g_ibers
gibes84422523g_ibe_s
gies55641423g_i_e_s
gigas75415583g_i_gas
gimels938893g_imels
gingal81010153g_ingal
gingals9109313g_ingals
gingers94118643g_ingers
ginks104319563g_in_ks
ginners84314223ginners
gins55543953g_in__s
gites65630183g_ite_s
givens10379733g_ivens
givers104817713g_ivers
gives95324873g_ive_s
glias64618493gli__as
glibness1134133glibness
gliders94811843gliders
glides84518863glide_s
glimes94717523glime_s
glints75714213glin_ts
gliomas1035333gliomas
glumness1135203glumness
goannas836223goannas
goings84911523goin_gs
goiters84014443goiters
gonefs10439873g_onefs
goners74420173g_oners
gooneys11407073gooneys
goriness9310753goriness
goutiness1038763goutiness
grainers93012073grainers
grides84422363gride_s
griefs10418723gri_efs
grimes94619033grime_s
grimness1175993grimness
grinders103410423grinders
grinds84511843grin_ds
gringa838553gringa_
gringos936673gringos
grinners9288043grinners
grins65427223grin__s
gripers104011463gripers
gripes94619873gripe_s
grivets11357973grivets
guanase836213guan_ase
guanay1037913guan_ay
guanays1134953guanays
guanines989773guanine_s
guanins8810013guanins
guanos73811993guan_os
guans64419443guan__s
guavas1037163gu_avas
gudes74520813gu_de_s
guenons836563guenons
guess64213363gu__ess
guglets9369693guglets
guide75019883guide__
guided94014113guide_d
guider84313523guide_r
guideway1642433guideway
guideways1742303guideways
guidons936623guidons
guids75516153gui__ds
guilders1035513guilders
guilds8388353gui_lds
guile64521133guile__
guiled84315383guile_d
guilts74111233gui_lts
guimpes1245073guimpes
guiros7389093gui_ros
guise64717713guise__
guised84612173guise_d
guitar7117443gui_tar
guitars8116863guitars
guldens9356573guldens
gules64831043gu_le_s
gullets84013713gullets
gulleys11438523gulleys
gulpers10299013gulpers
gumless10228273gumless
gumlines11238573gumline_s
gummas114810513gu_mmas
gummers123712203gummers
gumminess1454973gumminess
gunites8313123gunites
gunks104517723gu_n_ks
gunless8299633gunless
gunman9299453gu_nman
gunned83513093gunne_d
gunnel73411053gunne_l
gunnen7338713gunne_n
gunner73813983gunne_r
gunnery11376373gunnery
gunnies83413123gunnies
guns55533483gu_n__s
gunsels8338133gunsels
gurges84716863gurge_s
gurnet74920873gurne_t
gurney10429413gurne_y
gushers113512513gushers
gushes104719033gushe_s
gushiness13206853gushiness
gussets837443gussets
gustiness10189893gustiness
gutless82610713gutless
gutsiness10226963gutsiness
gutters83715513gutters
guylines12236943guyline_s
gwine95513663gwine__
iciness938863iciness
ideas65919013__ideas
iguanas835383iguan_as
imines84918353imine_s
joiners144211573joiners
juicers1636153juicers
juices1549423juice_s
juntas134210503ju_ntas
kinas95626913_kin_as
kinemas1336893_kinemas
kines95039133_kine_s
koines10415733koine_s
lineal65616023_lineal
linear65113343_linear
linens64818393_linens
liners65428853_liners
lines57054573_line_s
lingas75116573_lingas
lunas55025013lu_n_as
lunes55337773lu_ne_s
lunets66914763lu_nets
lunies64723013lunie_s
lupines93912503lupine_s
minas75434113_min_as
miners84126633_miners
mines75651953_mine_s
murines93718223murine_s
mutines93117823mutine_s
nines55937343_nine_s
ninjas1386303_ninjas
opines84820703opine_s
ovines94614343ovine_s
pinas75434453_pin_as
pineal84817683_pineal
pineals93212843_pineals
pines76048863_pine_s
pinnas85315513_pinnas
pintas85021393_pintas
puisnes937423puisne_s
punas74826753pu_n_as
puniness101610273puniness
punkas123410673pu_nkas
punners94114233punners
punnets9409263punnets
purines94420763purine_s
queleas1636723queleas
quiets154014373qui_ets
quinces183210433quinces
quinela1635213quinela
quinellas1843793quinellas
quinielas1852503quinielas
quininas17286033quininas
quinins162811293quinins
quinnat16116823quinnat
quinnats17124283quinnats
quinoa15377653quinoa_
quinols16297243quinols
quins144819853quin__s
quinta153312373quinta_
quintal16389883quintal
quintals17288003quintals
quintan16399223quintan
quintans17337873quintans
quintar16478603quintar
quintars17337563quintars
quintes164114713quintes
quintets17347203quintets
quints154316563quin_ts
quires154015743quire_s
quivers19298753quivers
ruanas6311263ruan_as
ruined74813323ruine_d
ruiner64013643ruine_r
ruinous739763ruinous
ruins55822033ruin__s
runes55530223ru_ne_s
runnels7329153runnels
runners74212453runners
seiners74219273seiners
seines65029903seine_s
shiners104015943shiners
shines95028913shine_s
sines55954823_sine_s
sinews94210623_sinews
spinels94512443spinels
spines85132033spine_s
spinets94714813spinets
spireas94412513spireas
subideas1146443subideas
subnets92512083subnets
suints64617783suin_ts
suiters73618883suiters
suites63727403suite_s
sunnas63914563su_nnas
supines94216383supine_s
tinea54923163_tinea_
tineal66216163_tineal
tines54848423_tine_s
trines64132563trine_s
tunas54224123tu_n_as
tuners64417343tu_ners
tunes55332193tu_ne_s
tunnels7328723tunnels
turners73912893turners
twiners10459633twiners
twines94717273twine_s
ugliness936863ugliness
ulnas55716533_uln_as
unease63816643_u_nease
uneasy9278853_u_neasy
ureas55826013_u_reas
urines64724123urine_s
usnea539393_usnea_
uveas84912283_u_veas
veiners104112523veiners
vinas85126343_vin_as
vincas113912453_vincas
vineal94814743_vineal
vines85137643_vine_s
weiners103913063weiners
whiners134011573whiners
whines125120103whine_s
wines85546863_wine_s
zinebs17606803_zinebs
zines145232653_zine_s

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.1561145455.1
2DLD Change Limit1340273256.40620922.1
3Display Results3253250.1102954.5
 (SQL Overall)1786913256.67226782.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.