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

136 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
utopias911772(None) 
utopia8107881utopia_
utopian9126271utopian
utopians1094901utopians
anopias92412482anopias
atonias73315992atonias
atopies92816432atopies
ectopias1248272ectopias
myopias14308152myopias
subtopias1345722subtopias
topics104714582_topics
topis76025832_topi_s
utopism1146332utopism
utopisms1245412utopisms
utopist938692utopist
utopists1045772utopists
anopia83412393anopia_
anopsias10337983anopsias
anoxias14259113anoxias
aporias9315153aporias
ataxias14189343ataxias
atomics113110853atomics
atomies93918363atomies
atonia63816513atonia_
atonics93613713atonics
atonies75320953atonies
atopic103514143atopi_c
atrophias1447933atrophias
atropins10410493atropins
autopens1046633autopens
autopsies1147193autopsies
biopics13318543biopics
capias10318353_capias
chopins142312243chopins
cobias104014993_cobias
copies104130303_copies
copras103517153_copras
dopas85019063_dop_as
dystopias1544883dystopias
ectopia1147693ectopia_
eulogias946553eulogias
glorias81610323glorias
hooplas1239203hooplas
hutzpas2142693hutzp_as
koppas14407603_koppas
meropias1249963meropias
myopia13318443myopia_
myopies14309723myopies
norias65518203_norias
nutrias739813nut_rias
obias76116863__obias
ohias84415573__ohias
phobias14228183phobias
photopias16410143photopias
pias66542553___pias
poppas93710713_poppas
potpies113116173potpies
ptosis83611823ptosi_s
scotias939753scotias
scotopias1345693scotopias
senopias1048823senopias
sepias83616103_sepias
sinopias1047873sinopias
stadias8411113stadias
stoas55126023sto__as
stogies8413693stogies
stoics8311113sto_ics
stomas84816323sto_mas
stopers94217373stopers
stopes84525893stop_es
stopgap1243533stopgap
stopgaps1342963stopgaps
stoping103716623stoping
stops74827283stop__s
stories7324273stories
stotins73213873stotins
stupas83910883stup_as
stupids1035273stupids
subtopia1245403subtopia_
subtopics1543733subtopics
tafias93111963_tafias
tapas74627713_tap_as
tapirs84113173_tapirs
tapis75028863_tapi_s
tenias64720073_tenias
tepas76521683_tep_as
thorias102312053thorias
tibias839953_tibias
tipis76019923_tipi_s
tobies84521023_tobies
todies74223553_todies
toeas55726423_to_eas
togas67823003_to_gas
toils54527493_to_ils
toits55327473_to_its
tolas54532773_to_las
tongas74315523_tongas
tonics83617863_tonics
topaz16315323_top_az
topees85519703_topees
topers85025323_topers
topes76941763_top_es
tophes115218423_tophes
tophs105220053_top_hs
tophus115210363_tophus
topi67830393_topi__
topiary1245813_topiary
topic95721503_topi_c
topical1139953_topical
toping94122993_toping
topmast1138123_topmast
topos75726393_top_os
tops66248123_top__s
toras55540373_to_ras
torics85118353_torics
tories65435883_tories
torpids1037373_torpids
tortas64918253_tortas
towies93521193_towies
toxics153910203_toxics
toxins133314283_toxins
tropics113610653tropics
tropins93116313tropins
tupiks1235493_tupiks
tutorial847833tutorial
tutorials945133tutorials
unpins82312383u_npins
upas68322383u__p_as
uranias72113813uranias
urbias839093u_rbias
uremias9249503uremias
uropods1035873uropods
utas45924953ut___as
utopianism1452583utopianism
uxorial1446323uxorial
yttrias1044523yttrias

Search took 9 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.403443402.0
2DLD Change Limit1340271368.41015936.6
3Display Results1361360.0462956.5
 (SQL Overall)1786911368.85920170.6
 
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.