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

166 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
utopia810788(None) 
utopian9126271utopian
utopias9117721utopias
anopia83412392anopia
atonia63816512atonia
atopic103514142atopic
ectopia1147702ectopia
myopia13318442myopia
subtopia1245402subtopia
topi67830392_topi_
topic95721502_topic
topis76025832_topis
utopians1094902utopians
utopism1146332utopism
utopist938692utopist
alodia71112453alodia
anopias92412483anopias
anopsia9258443anopsia
anoxia133510023anoxia
aporia8315863aporia
ataxia13179593ataxia
atomic104115603atomic
atonias73315993atonias
atonic83420473atonic
atop66124753atop__
atopies92816433atopies
atopy106813393atop_y
atria56022353at_ria
atrophia1348123atrophia
atropin9311583atropin
atypic13337653atypic
autopen947123autopen
autopsic1246063autopsic
autopsy1244373autopsy
biopic123710673biopic
chopin132712193chopin
cobia94117513_cobia
copra98115463_copra
coria75828323_coria
dopa77220903_dop_a
dystopia1444833dystopia
ectopias1248283ectopias
ectopic1338163ectopic
entopic1149953entopic
eulogia846663eulogia
folia83618933_folia
gloria71910553gloria
gonia64117533_gonia
gopik1257533_gopik
hoopla1147633hoopla
hutzpa2052813hutzp_a
koppa13397293_koppa
logia68116603_logia
meropia1149623meropia
metopic1339763metopic
myopias14308153myopias
myopic15308463myopic
noria55722183_noria
nutria639913nut_ria
obia67923113__obia
octopi1036533octopi_
ohia75719363__ohia
phobia13278603phobia
photopia1549733photopia
pia56848043___pia
podia8415283_podia
poppa8409893_poppa
potpie103412433potpie
propria1149933propria
ptosis83611823ptosis
ptotic102713373ptotic
scoria8513503scoria
scotia8310803scotia
scotopia1245733scotopia
senopia949233senopia
sepia75318673_sepia
sinopia947743sinopia
stadia7312143stadia
stoa45425913sto__a
stoai55417873stoai_
stogie7311323stogie
stoic7317253sto_ic
stolid74213183stolid
stoma75918273sto_ma
stop66532033stop__
stope74727243stop_e
stoped94721013stoped
stoper84320103stoper
stopes84525893stopes
stopgap1243533stopgap
stoping103716623stoping
stops74827283stop_s
stopt76528353stop_t
stotin63215063stotin
stria55723213st_ria
stupa74112313stup_a
stupid937593stupid
subtopias1345723subtopias
subtopic1445073subtopic
tafia84215493_tafia
tapa65129153_tap_a
tapir75917063_tapir
tapis75028863_tapis
telia55821143_telia
tenia55324483_tenia
tepa66021683_tep_a
tepid8314313_tepid
thoria93012893thoria
tibia7312403_tibia
tipi69924443_tipi_
tipis76019923_tipis
toea46732333_to_ea
toga57027413_to_ga
toil46536283_to_il
toit46353063_to_it
tola45236333_to_la
tonga65619703_tonga
tonic74727653_tonic
top510560683_top__
topaz16315323_topaz
tope65946383_top_e
toped85631313_toped
topee76029953_topee
toper75231023_toper
topes76941763_topes
toph96326873_top_h
tophe106718973_tophe
tophi105215303_tophi
tophs105220053_tophs
topiary1245813_topiary
topical1139953_topical
topics104714583_topics
toping94122993_toping
topo66932403_top_o
topoi76018353_topoi
topos75726393_topos
tops66248123_top_s
tora47545993_to_ra
tori47542153_tori_
toric76529313_toric
torii55521593_torii
torpid9310913_torpid
torta55925353_torta
towie85821873_towie
toxic145315623_toxic
toxin124716713_toxin
tropic103014193tropic
tropin83316753tropin
tupik1149003_tupik
tutorial847833tutorial
typic124511963_typic
uncia75015163u_ncia
unopen838913unopen
unpin72613243u_npin
urania62516123urania
urbia7311143u_rbia
uredia73610063uredia
uremia82910893uremia
uropod937263uropod
uropygia1452303uropygia
uta37425583ut___a
uteri51012983uteri_
utopisms1245413utopisms
utopists1045773utopists
uxorial1446323uxorial
yttria954803yttria

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.376475242.0
2DLD Change Limit1127161665.17021801.9
3Display Results1661660.0463608.7
 (SQL Overall)1786911665.59231954.8
 
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.