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

360 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
citrons9291322(None) 
cistrons102710621cistrons
citrins92614361citrins
citron83112981citron_
citrous93112991citrous
bicrons113410472bicrons
biotrons1037232biotrons
cartons94122472cartons
cations94524142cations
chitons122611912chit_ons
cions75222852ci__ons
cirrous93111062cirrous
cistron9299882cistron_
cithrens13355932cithrens
citrals91111672citrals
citreous1056852citreous
citrin82615412citrin_
citrine92514022citrine
citrines102513132citrines
citrus83610922citr_us
coitions10312852coitions
cottons9312192cottons
cytons111710182cyt_ons
diatrons939612diatrons
diurons838822diurons
girons75014372gi_rons
introns73515022introns
irons55324132_i_rons
matrons93517632matrons
microns113814782microns
mikrons13428412mikrons
natrons73215662natrons
nitons64614902nit_ons
nitros64214122nitro_s
nitrous73512482nitrous
patrons93818102patrons
pitons85319042pit_ons
waitrons1136632waitrons
actinons10389453actinons
actions94218513actions
ailerons849843ailerons
airns55521033ai_r_ns
aprons8316993_aprons
attorns738443attorns
barons85025383_barons
batons85519423bat_ons
betons84919553bet_ons
bicorns11338763bicorns
bicron103710773bicron_
billons93013363billons
biotron937293biotron_
biros75325133bi_ro_s
bisons83914373bi_sons
bistros92810983bistro_s
borons85520543_borons
burtons9310853burtons
buttons9310333buttons
cairns85313303cair_ns
caissons1036283caissons
caldrons1138063caldrons
caltrops12307863caltrops
calutrons1145503calutrons
camions113916133camions
cannons94412883cannons
canons85522063c_anons
cantons95221203cantons
canyons124511593canyons
capons104119503c_apons
captions123813223captions
carbons115418943carbons
cardons104519933cardons
carns75937563c_ar_ns
carobs104818103c_arobs
carols85124983c_arols
caroms105619573c_aroms
carrions10312453carrions
carroms11512403carroms
carrots9714623carrots
carryons1337103carryons
carton84522663carton_
cartoons104012803cartoons
caterans10313223caterans
cation83925503cation_
catkins133012563catkins
catlins93818843catlins
cautions103313183cautions
ceros74726073c_ero_s
cerous85821203c_erous
chevrons1665463chevrons
chiffons1943693chiffons
chignons1444713chignons
chiros114617773chiro_s
chitins122713793chit_ins
chitlins13289393chitlins
chiton112612393chit_on_
chorions13310663chorions
churns114910233chur_ns
cibols1039523ci_bols
cicerone1247523cicerone
cicerones1347073cicerones
ciceroni1244853ciceroni
ciceros1158583cicero_s
cineols9128853cineols
cinerins10414103cinerins
cion613330913ci__on_
ciphony1744973ciphony
circus104310593ci_rcus
cires74932913ci_r_es
cirrose937473cirrose
cirrus8349173ci_rrus
ciscoes113610733ciscoes
ciscos104711133cisco_s
cisterns10369573cisterns
cistronic1345473cistronic
citations11312503citations
citators10310253citators
citers85022983cit_ers
cites74435593cit__es
citherns13338873citherns
cithers124315773cithers
cithren12306593cithren_
cities84524853cit_ies
citing94220183cit_ing
citizens1943983citizens
citola838393cit_ola
citolas939363citolas
citole8311503cit_ole
citoles9312553citoles
citral81113893citr_al
citrate92216803citrate
citrates102315093citrates
citric102812313citr_ic
citrinin1045783citrinin
citrinins1145583citrinins
citruses1037483citruses
citrusy12284183citrusy
citterns10318123citterns
clarions10310493clarions
claroes93113733claroes
claros84015113claro_s
claxons1635803claxons
clitoris1047873clitoris
clons75228133c__lons
cocoons11310563cocoons
codons96119463c_odons
cogons96818113c_ogons
coition9314313coition_
colons86028683c_olons
commons13311043commons
cons66057693c___ons
controls10311393controls
coons76737283c__oons
copatrons1346333copatrons
cordons104415763cordons
corns76034763c_or_ns
corona83817403c_orona
coronas93916913c_oronas
cortins92421333cortins
cotans81317923cot_ans
cotton8312993cotton_
cottony1237253cottony
coupons112710563coupons
cratons94316033cratons
crayons12439233crayons
crepons1139313crepons
cribrous1246013cribrous
crimsons1245633crimsons
criterions1244763criterions
crocs95722433c__rocs
crone75231333c__rone
crones84729243c__rones
crony105918673c__rony
croons85418423c_roons
crops96125233c__rops
cross75124503c__ross
crotons93714373crotons
crowns115615113c__rowns
crows105727313c__rows
cryotrons1444743cryotrons
cuatros938273cuatro_s
cuprous1149743cuprous
curns74924273c_ur_ns
currans9310613currans
cutdowns1443343cutdowns
cutins83919983cut_ins
cyton101511463cyt_on_
dacrons103211033dacrons
diatron839283diatron_
dictions111812673dictions
dittos74111973ditto_s
diuron738573diuron_
editions9310403editions
eikons1038503ei_kons
enterons8314153enterons
estrins7315853estrins
estrone7413953estrone
estrones8313323estrones
estrous7712533estrous
excitons1746043excit_ons
fibrins1238633fibrins
fibroins1346213fibroins
fibrous1237593fibrous
fictions132410743fictions
firns86018543fi_r_ns
frons86124043__frons
futons93911513fut_ons
garrons82713463garrons
gibbons1234983gibbons
gibsons1045043gibsons
gipons9389603gi_pons
girns64516803gi_r_ns
giron66118993gi_ron_
giros65722653gi_ro_s
gitanos837173gitanos
goitrous945763goitrous
gyrons105511223_gyrons
hadrons113314303hadrons
herons94820543_herons
hotrods1148283hotrods
icons76516493_i_cons
ignitrons1042993ignitrons
ikons96311013_i_kons
inions64417003_inions
inruns6359513_inruns
intron64215023intron_
intros64215773intro_s
ions46737853_i__ons
iron46728463_i_ron_
irone55126363_i_rone
irones64724013_i_rones
irony85015903_i_rony
jetons134512613jet_ons
jettons1437273jettons
kations114013663kations
kirns95315453ki_r_ns
kittens11347583kittens
ladrons83813193ladrons
ligroins946823ligroins
linurons846333linurons
lions55923213li__ons
lithops12307253lithops
lithos94212553litho_s
litres65220393litr_es
lotions74614763lotions
macrons113514893macrons
marrons93216973marrons
matron83918313matron_
metros84217803metro_s
micron103714283micron_
micros104115363micro_s
midirons1145883midirons
mignons1037863mignons
mikron12318503mikron_
minions93314623minions
mirins83918903mi_rins
mirrors938623mirrors
mitres83922073mitr_es
mitring103514143mitring
mittens9349883mittens
morons84919543_morons
motions94215003motions
mutons84314363mut_ons
muttons949283muttons
nations74720563nations
natron64116023natron_
neurons7410443neurons
neutrons838293neutrons
nimrods1044283nimrods
ninons64913773ni_nons
niton55418283nit_on_
nitres65519333nitr_es
nitrids8269633nitrids
nitrils72810703nitrils
nitro54914353nitro__
nitrogens1045353nitrogens
nitroso7326453nitroso
notions74014483notions
octrois938333octrois
omicrons1275193omicrons
omikrons1462963omikrons
operons91411743operons
options93810603options
outrows10311403outrows
outruns72911543outruns
partons94620513partons
patrols93513513patrols
patron84018043patron_
patroons102710603patroons
perrons93115483perrons
petrols92913083petrols
petrous92714423petrous
pigeons1039183pigeons
pinions93413603pinions
pinons86019943pi_nons
pinyons12299003pinyons
pions75826393pi__ons
pirns76020093pi_r_ns
pistons93016373pistons
piteous9310683piteous
pitmans11188743pitmans
piton76121583pit_on_
pliotrons1144703pliotrons
positrons1186543positrons
potions93417423potions
putons83515153put_ons
pythons1537363pythons
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
retros63820193retro_s
ribbons1136253ribbons
scions82612243sci__ons
setons64620173set_ons
simoons937943simoons
siphons1239353siphons
sirens65318153si_rens
sitcoms1145533sitcoms
sithens1039383sithens
strong74914883_strong
strops86220383_strops
strows96718273_strows
stroys95914603_stroys
thorons104511913thorons
tiglons837343tiglons
tigons74112263ti_gons
tiros54524893ti_ro_s
titans63414913tit_ans
titians72710453titians
titrant7315193titrant
titrants838483titrants
titres64718933titr_es
tons46553053__t_ons
toons55027533__toons
trans54933043__trans
tritons73814883trit_ons
trogs67022603__trogs
trois57226093__trois
trona54118953__trona
tronas63816903__tronas
trone55131863__trone
trones65629283__trones
trots56629943__trots
trows88826183__trows
troys86418613__troys
tuitions838283tuitions
vibrions1345093vibrions
virions1039873virions
visions10311023visions
vitrains1138283vitrains
vitreous1145843vitreous
vitrics12198553vitrics
vitrine102511363vitrine
vitrines112610913vitrines
vitriols1145053vitriols
waitron1036333waitron_
wigeons1136983wigeons
witans93412933wit_ans
withins133511693withins
wittols1035733wittols
zircons1854963zircons

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.1401276364.3
2DLD Change Limit1340273606.33021173.3
3Display Results3603600.1232926.8
 (SQL Overall)1786913606.59327103.1
 
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.