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

265 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
cinema104765(None) 
cinemas1138041cinemas
kinema1236021kinema
cine66242942cine__
cineol8108202cineol
cines75239682cine_s
enema7612742_enema
kinemas1336892kinemas
lineman939122lineman
minima105512652minima
nema65522522__nema
pineta85815562pineta
tinea54923162tine_a
acidemia1344783acidemia
adnexa1433673adnexa
anemia82613573_anemia
anima74620073_anima
apnea73413413apne_a
bema85825253__bema
bima86723833bi__ma
bine66650863bine__
biner75930693bine_r
biners85023633biners
bines76946793bine_s
bireme10310143bireme
caeca93915133c_aeca
caeoma1039033caeoma
calesa8412473calesa
camera10313693camera
cancha134411613cancha
candela1089743candela
cane66653123cane__
caned85838093cane_d
canella9310793canella
caner75334773cane_r
caners84629203caners
canes75350373cane_s
canna75919333can_na
canola8313623canola
canula8312963canula
catena8312483catena
caveman1437073caveman
ceca84820783c__eca
centra84113883centra
chacma1537903chacma
chaeta11310683chaeta
chela103916803c_hela
chemo12313633c_hemo
chiasma14366993chiasma
chimera14389273chimera
china105022483chin__a
chine105231723chine__
chined125620063chine_d
chines115029173chine_s
chroma132912473chroma
cicada1136413cicada
cicala10310053cicala
cicely1338833cicely
cicero1048503cicero
cider84723313cide_r
ciders94620093ciders
cilia73016763ci_lia
cimex16119133cime_x
cinch124516243cin_ch
cinder94119123cinder
cinders104617763cinders
cindery13429193cindery
cineast9310523cineast
cinematic1546383cinematic
cineole91010003cineole
cineols9128853cineols
cinerary1346433cinerary
cinerin9313823cinerin
cingula10327173cingula
cinque1736853cinque
circa9311403ci_rca
cire65836373cire__
cires74932913cire_s
cite65640343cite__
cited84421953cite_d
citer74827333cite_r
citers85022983citers
cites74435593cite_s
citola838393citola
civet105828733cive_t
civets115212543civets
cline76428533cline__
clines84926043cline_s
cnida878953c_nida
cocinera1245553cocinera
codeia94112193codeia
coined94523603coine_d
coiner84323783coine_r
coiners93620753coiners
coma87134853c__oma
comma114514793c_omma
concha134213283concha
condemn1237113condemn
cone67256963cone__
coned86040053cone_d
cones76457423cone_s
coney105932883cone_y
coneys115218423coneys
conga85419873con_ga
contemn1137803contemn
contra83314703contra
coremia11310363coremia
cornea84018923corne_a
cream95721343c_ream
creme94319323c_reme
crinum1039333crinum_
crinums1135863crinums
cuneal8611513cuneal
cyma116715843c__yma
dilemma1243063dilemma
dine55555333dine__
dined76431993dine_d
diner65632903dine_r
dinero75612643dinero
diners75525953diners
dines66449153dine_s
eczema1973073eczema
edema8610553_edema
enemas8812003_enemas
enemy1059993_enemy
enigma935643enigma
fanega1055783fanega
finca104714503fin_ca
fine75147953fine__
fined94930503fine_d
finely123011563finely
finer85431563fine_r
finery124512893finery
fines86644263fine_s
finest94321733finest
fireman1249333fireman
genera71211713genera
geneva1085853geneva
guinea737613guine_a
hiemal11339503hi_emal
iceman1037853_iceman
iciness938863iciness
idea59122773_ide_a
idem76121063_idem_
ilea45931463_ile_a
inept73622153_inept
inert53234373_inert
infra838643_infra
inia45024703_in_ia
inseam8329993_inseam
intima81910033_intima
item65620383_item_
items7499613_items
jicama1734883jicama
kina85631993kin__a
kinara10310373kinara
kine85643423kine__
kines95039133kine_s
kinsman1335963kinsman
lima65734133li__ma
line46965573line__
lineal65616023lineal
linear65113343linear
lined64934643line_d
linemen938633linemen
linen55728723line_n
linens64818393linens
lineny94011443lineny
liner55938923line_r
liners65428853liners
lines57054573line_s
linesman1046253linesman
lineup835983lineup
liney87029633line_y
linga66820823lin_ga
lingam95112353lingam
lingua7509913lingua
linkman1335393linkman
linum7313823linum_
linums838283linums
lipoma1046753lipoma
miasma1097563miasma
mina65136923min__a
mine67256173mine__
mined85333353mine_d
miner76933543mine_r
mineral9312733mineral
miners84126633miners
mines75651953mine_s
minim97321603minim_
minimal114010603minimal
minimax18376013minimax
minims104514813minims
nemas75321573__nemas
nine45842173nine__
nines55937343nine_s
ninety9510963ninety
ninja1258093nin_ja
noma67529463__noma
oedema936573oedema
panama104213353panama
pieta75421753pi_eta
pikeman1535523pikeman
pilea75123953pile_a
pima85428653pi__ma
pina65842633pin__a
pinata83817223pinata
pine67755713pine__
pineal84817683pineal
pined85935323pine_d
pinene82915643pinene
pinery115214293pinery
pines76048863pine_s
pinesap1164723pinesap
piney105727503pine_y
pinna75320183pin_na
pinta75727053pin_ta
pneuma1035263_pneuma
quinela1635213quinela
schema1388373schema
seneca839793seneca
senega738173senega
sideman1037973sideman
sienna647193sienna
sigma84513833si_gma
sima64730783si__ma
sine46560623sine__
sines55954823sine_s
sinew84718923sine_w
sinews94210623sinews
sinewy12667513sinewy
tine45855133tine__
tineal66216163tineal
tineas64616483tineas
tined65434533tine_d
tineid74412023tineid
tines54848423tine_s
tinman82411143tin_man
tinmen82310403tinmen
toneme8312103toneme
ulema7109713_ulema
urinemia1043953urinemia
usnea539393usne_a
vina76331803vin__a
vinca105315163vin_ca
vine75643683vine__
vineal94814743vineal
vined95626153vine_d
vinegar1134613vinegar
vinery124912603vinery
vines85137643vine_s
viremia1246083viremia
wine74953423wine__
wined94434183wine_d
winery125014283winery
wines85546863wine_s
winesap1264443winesap
winey115325433wine_y
wingman1336383wingman
wireman1237843wireman
zine137036153zine__
zineb165614143zine_b
zinebs17606803zinebs
zines145232653zine_s
zinnia1536013zinnia

Search took 6 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162655.22021593.1
3Display Results2652650.0932849.5
 (SQL Overall)1786912655.46932673.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.