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

180 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
zircons185496(None) 
zircon1754951zircon_
bicrons113410472bicrons
garcons102411642garcons
girons75014372gir_ons
icons76516492_i_cons
irons55324132_ir_ons
microns113814782microns
virions1039872virions
zincous1837052zincous
zirconia1943132zirconia
zirconias2043022zirconias
zirconic2144012zirconic
airns55521033air__ns
aprons8316993apr_ons
archons12311583_archons
argons75018203_argons
arsons63917213_arsons
bacons104917583_bacons
barons85025383bar_ons
baryons121010473baryons
beacons11410733beacons
bicorns11338763bi_corns
bicron103710773bicron_
billons93013363billons
birches143412323birches
biros75325133bir_o_s
bisons83914373bi_sons
borons85520543bor_ons
burtons9310853burtons
carbons115418943carbons
cardons104519943cardons
cartons94122473cartons
cions75222853ci__ons
circles1139903circles
circus104310593circ_us
cirrous93111063cirrous
ciscoes113610733ciscoes
ciscos104711133cisco_s
citrons92913223citrons
cons66057693___cons
cordons104415763cordons
croons85418423_croons
dacrons103211033dacrons
deacons10310393deacons
dicots94915793di_cots
discos94915213disco_s
diurons838823diurons
durions839963durions
eikons1038503ei_kons
falcons1239123falcons
ficins113513983fi_cins
ficoes114613463fi_coes
firkins1437663firkins
firmans12238523firmans
firns86018543fir__ns
flacons1238053flacons
frons86124043_fr_ons
garcon92912483garcon_
garrons82713463garrons
gascons10289103gascons
gibbons1234983gibbons
gibsons1045043gibsons
gipons9389603gi_pons
girns64516803gir__ns
giron66118993gir_on_
giros65722653gir_o_s
gorgons938853gorgons
grisons838993grisons
gyrons105511223gyr_ons
herons94820543her_ons
hircine1239143hircine
icon66922043_i_con_
icones84616383_i_cones
ikons96311013_i_kons
incogs937903_incogs
incony1139083_incony
inions64417003_inions
ions46737853_i__ons
iron46728463_ir_on_
irone55126363_ir_one
irones64724013_ir_ones
irony85015903_ir_ony
jargons1558203jargons
kirns95315453kir__ns
kroons103711243_kroons
lardons83914493lardons
limacons1243953limacons
lions55923213li__ons
lyricons1343583lyricons
macons104017243_macons
macrons113514893macrons
maroons92615553maroons
marrons93216973marrons
mascons113411583mascons
merlons93311273merlons
micron103714283micron_
micros104115363micro_s
mignons1037863mignons
mikrons13428413mikrons
minions93314623minions
mirins83918903mir_ins
mirrors938623mirrors
miscoins12311083miscoins
morions94014643morions
morons84919543mor_ons
narcos86714203narco_s
neocons936913neocons
niacins938543niacins
nicols8810243ni_cols
ninons64913773ni_nons
nitons64614903ni_tons
oilcans936813oilcans
omicrons1275193omicrons
orcins83313433_orcins
orisons7310563orisons
orlons6411013_orlons
pardons103817623pardons
parsons93516873parsons
partons94620513partons
pereons92815003pereons
perrons93115483perrons
persons93717013persons
picots104616443pi_cots
pigeons1039183pigeons
pinions93413603pinions
pinons86019943pi_nons
pinyons12299003pinyons
pions75826393pi__ons
pirns76020093pir__ns
piscos105112593pisco_s
pistons93016373pistons
pitons85319043pi_tons
prions84317783_prions
prisons9313223prisons
racons84319343_racons
recons84922993_recons
ribbons1136253ribbons
ricins83618703ri_cins
sarcous9312933sarcous
sermons9311783sermons
silicons10107163silicons
simoons937943simoons
siphons1239353siphons
sirens65318153sir_ens
sirloins836723sirloins
sitcoms1145533sitcoms
tarpons92612213tarpons
tiglons837343tiglons
tigons74112263ti_gons
tiros54524893tir_o_s
torchons1337503torchons
tricorns1036683tricorns
tricots9311563tricots
trigons84312093trigons
tritons73814883tritons
turions7311573turions
turnons737863turnons
vibrions1345093vibrions
vidicons1443863vidicons
vireos94212453vireo_s
virgins1137863virgins
virion9310683virion_
viscous1238833viscous
visions10311023visions
wiccans1434603wiccans
wigeons1136983wigeons
zeroes154314343zer_oes
zeros144918113zer_o_s
zilches21326303zilches
zillions17168073zillions
zincing192910283zincing
zincoid1946663zincoid
zincs165312933zinc__s
zins135735003zi___ns
zirams17438643zir_ams
zircaloys2351053zircaloys
zirconium2252533zirconium
zirconiums2352103zirconiums
zoons144919693z__oons

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.406440125.6
2DLD Change Limit1340271806.15621771.8
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.62526972.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.