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 “cinemas” 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.

194 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
cinemas113804(None) 
cinema1047651cinema_
kinemas1336891kinemas
cineast9310522cine_ast
cineols9128852cineols
cines75239682cine__s
enemas8812002_enemas
kinema1236022kinema_
lineman939122lineman
nemas75321572__nemas
tineas64616482tine_as
acidemias1444503acidemias
anemias92512143_anemias
animas84418723_animas
apneas83211383apne_as
bemas96424283__bemas
bimas95521743bi__mas
biners85023633bine_rs
bines76946793bine__s
biremes1138773biremes
caeomas1138403caeomas
calesas9411833calesas
camas96333523c__amas
cameras11313363cameras
canchas143212403canchas
candelas1139533candelas
canellas10310563canellas
caners84629203cane_rs
canes75350373cane__s
cannas84518403can_nas
canolas9313993canolas
canulas9312853canulas
canvas113813333can_vas
catenas9313113catenas
caveman1437073caveman
centas85020703cen_tas
chacmas1638003chacmas
chelas113817203c_helas
chemos13311723c_hemos
chiasmas15306593chiasmas
chimeras15388833chimeras
chinas115119403chin__as
chines115029173chine__s
chromas142512693chromas
cicadas1235993cicadas
cicalas1139303cicalas
ciceros1158583ciceros
ciders94620093cide_rs
cinches144215773cinches
cinders104617763cinders
cine66242943cine___
cineaste1045743cine_aste
cineasts1045543cineasts
cinematic1546383cinematic
cineol8108203cine_ol
cineole91010003cineole
cineoles10109403cineoles
cinerary1346433cinerary
cinerin9313823cinerin
cinerins10414103cinerins
cinques1837333cinques
cires74932913cire__s
citers85022983cite_rs
cites74435593cite__s
citolas939363citolas
civets115212543cive_ts
clines84926043cline__s
cocineras1344963cocineras
codeias103911223codeias
coiners93620753coine_rs
comas95833003c__omas
commas124814573c_ommas
conchas144013313conchas
condemns1336293condemns
cones76457423cone__s
coneys115218423cone_ys
congas94417033con_gas
contemns1237403contemns
contras93015623contras
corneas94717003corne_as
creams104715253c_reams
cremes104517993c_remes
crinums1135863crinum_s
cuneal8611513cune_al
cymas126417883c__ymas
dilemmas1343123dilemmas
dineros83812333dineros
diners75525953dine_rs
dines66449153dine__s
eczemas2063143eczemas
edemas9310503_edemas
enema7612743_enema_
enigmas1045173enigmas
fanegas1145713fanegas
fincas113512073fin_cas
fines86644263fine__s
fireman1249333fireman
genevas1185253genevas
guineas836753guine_as
hiemal11339503hi_emal
iceman1037853_iceman
iciness938863icine_ss
ideas65919013_ide_as
inerts64517023_inerts
inseams9307903_inseams
intimas9119583_intimas
items7499613_item_s
jicamas1845053jicamas
kinaras1159123kinaras
kinas95626913kin__as
kines95039133kine__s
kineses113111253kineses
kinesis11259593kinesis
kinsman1335963kinsman
limas75627633li__mas
lineal65616023line_al
linear65113343line_ar
linemen938633linemen
linens64818393line_ns
liners65428853line_rs
lines57054573line__s
linesman1046253linesman
lineups934913lineups
lingams104510193lingams
lingas75116573lin_gas
linkman1335393linkman
linums838283linum_s
lipomas1156443lipomas
miasmas1167743miasmas
minas75434113min__as
mineral9312733mineral
minerals10311373minerals
miners84126633mine_rs
mines75651953mine__s
minima105512653minima_
minimal114010603minimal
minimals12327433minimals
minimax18376013minimax
minims104514813minim_s
nema65522523__nema_
nines55937343nine__s
ninjas1386303nin_jas
nomas74726413__nomas
oedemas1056693oedemas
panamas113112763panamas
pietas84516503pi_etas
pikeman1535523pikeman
pimas94725103pi__mas
pinas75434453pin__as
pinatas93711503pinatas
pineal84817683pine_al
pineals93212843pineals
pinenes93416673pinenes
pines76048863pine__s
pinesap1164723pinesap
pinesaps1253983pinesaps
pineta85815563pineta_
pinnas85315513pin_nas
pintas85021393pin_tas
pneumas1145103_pneumas
quinelas1744933quinelas
schemas1468163schemas
senecas939013senecas
senegas837253senegas
sideman1037973sideman
siennas736123siennas
sigmas94111363si_gmas
simas75727553si__mas
sines55954823sine__s
sinews94210623sine_ws
tinea54923163tine_a_
tineal66216163tine_al
tineids8337873tineids
tines54848423tine__s
tinman82411143tin_man
tonemes9311683tonemes
ulemas888963_ulemas
urinemias1143713urinemias
usneas638333usne_as
vinas85126343vin__as
vincas113912453vin_cas
vineal94814743vine_al
vinegar1134613vinegar
vinegars1245063vinegars
vines85137643vine__s
viremias1345873viremias
wines85546863wine__s
winesap1264443winesap
winesaps1364553winesaps
wingman1336383wingman
wireman1237843wireman
zinebs17606803zine_bs
zines145232653zine__s
zinnias1635863zinnias

Search took 10 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.1401276364.3
2DLD Change Limit1340271949.07614767.2
3Display Results1941940.0802425.0
 (SQL Overall)1786911949.29619222.4
 
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.