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

198 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
zircon175495(None) 
zircons1854961zircons
bicron103710772bicron
garcon92912482garcon
giron66118992gir_on
icon66922042_i_con
iron46728462_ir_on
micron103714282micron
virion9310682virion
zirconia1943132zirconia
zirconic2144012zirconic
airman82414223airman
airmen82612353airmen
airn46433843air__n
ancon75718233_ancon
apron7318833apr_on
archon11311753_archon
arco68331543_arco_
argon65520593_argon
arson55118833_arson
bacon95620593_bacon
baron78131243bar_on
baryon111211613baryon
beacon10511373beacon
bicorn103610103bi_corn
bicrons113410473bicrons
billon83713833billon
birch124914023birc_h
birchen14347883birchen
biro66131223bir_o_
biros75325133bir_os
bison75716983bi_son
boron76727143bor_on
burton8311273burton
carbon104919043carbon
cardon94120853cardon
carton84522663carton
cion613330923ci__on
circa9311403circ_a
circle1039703circle
circus104310593circus
cisco95112133cisco_
ciscos104711133ciscos
citron83112983citron
con510268023___con
cordon95017293cordon
croon75522783_croon
dacron94310693dacron
deacon9510423deacon
dicot85429093di_cot
disco85616073disco_
discos94915213discos
diuron738573diuron
durion7510963durion
eikon939463ei_kon
falcon11310293falcon
ficin103516723fi_cin
fico95824603fi_co_
firkin1337823firkin
firman112211343firman
firn76927513fir__n
flacon1138633flacon
garcons102411643garcons
garron73113493garron
gascon9339723gascon
gibbon1135323gibbon
gibson935123gibson
gipon84212413gi_pon
girn56026873gir__n
giro55828643gir_o_
girons75014373gir_ons
giros65722653gir_os
gorgon8310243gorgon
grison7310103grison
gyron95314623gyr_on
hereon93914363hereon
heron85025503her_on
hircine1239143hircine
icons76516493_i_cons
ikon85814963_i_kon
incog838253_incog
incony1139083_incony
inion54620183_inion
ion36051033_i__on
irone55126363_ir_one
irons55324133_ir_ons
irony85015903_ir_ony
jargon1448823jargon
kirn87123453kir__n
kroon94514483_kroon
lardon74415063lardon
limacon1144143limacon
lion46334453li__on
lirot5430033lir_ot
lyricon1243713lyricon
macon94519953_macon
macron103615673macron
maroon83118203maroon
marron83717543marron
mascon103612743mascon
merlon83012353merlon
micro94715993micro_
microns113814783microns
micros104115363micros
mignon937953mignon
mikron12318503mikron
minion83416243minion
mirin75023153mir_in
mirror848003mirror
miscoin11311433miscoin
morion86217733morion
moron76925423mor_on
narco76718243narco_
narcos86714203narcos
neocon836713neocon
niacin8310223niacin
nicol71113293ni_col
ninon55517383ni_non
niton55418283ni_ton
oilcan837793oilcan
omicron1165063omicron
orcin72716573_orcin
orison6411663orison
orlon5415003_orlon
pardon94618733pardon
parson83817903parson
parton84720993parton
pereon83517453pereon
perron83216623perron
person83517873person
picot95031013pi_cot
pigeon949413pigeon
pinion83815893pinion
pinon76024533pi_non
pinyon11459763pinyon
pion67235303pi__on
pirn67128383pir__n
pirog83913673pir_og
pisco96314983pisco_
piscos105112593piscos
piston83515923piston
piton76121583pi_ton
prion75119993_prion
prison8514023prison
racon75422143_racon
recon75624243_recon
ribbon1036533ribbon
ricin74620213ri_cin
sermon8413553sermon
siccan1037593siccan
silicon9117533silicon
simoon858063simoon
siphon1138463siphon
siren54525823sir_en
sirloin747593sirloin
sitcom1036903sitcom
tarpon82812803tarpon
tiglon737923tiglon
tigon63914443ti_gon
tiro46832373tir_o_
tiros54524893tir_os
torchon1237363torchon
tricorn937963tricorn
tricot8317753tricot
trigon74513103trigon
triton63914893triton
turion6313163turion
turnon638193turnon
vibrion1245253vibrion
vidicon1343783vidicon
vireo84816453vireo_
vireos94212453vireos
virgin1038083virgin
virions1039873virions
vision9311313vision
wiccan1335033wiccan
wigeon1037223wigeon
wilco1039443wilco_
zero134822473zer_o_
zeros144918113zer_os
zilch19438123zilc_h
zillion16188773zillion
zin125643783zi___n
zinc156819103zinc__
zinced18419413zinced
zincic1935903zincic
zincing192910283zincing
zincky24404963zincky
zincoid1946663zincoid
zincous1837053zincous
zincs165312933zinc_s
zincy195413513zinc_y
ziram163912893zir_am
zirams17438643zirams
zircaloy2241873zircaloy
zirconias2043023zirconias
zirconium2252533zirconium
zoon137326983z__oon

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 Filter1786911127160.360496363.9
2DLD Change Limit1127161985.61020092.0
3Display Results1981980.0633142.9
 (SQL Overall)1786911986.03329618.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.