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 “moidore” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
moidore105615(None) 
moidores1156341moidores
moire71017322moi__re
adore65723673__adore
amidone10349313amidone
bandore10611633bandore
bordure1035783bordure
condole102914953condole
condone102616293condone
condor94616973condor_
condores113315643condores
condors104018573condors
dore56353303___dore
epidote1037393epidote
forbore12249673forbore
fordone1149383fordone
goitre7349003goi_tre
madre85720173m_ad_re
maigre9309163mai_gre
mediocre1343473mediocre
middle103414983m_iddle
midge95016553m_id_ge
midsole1037813m_idsole
milord999573m_ilord
minor74920063m_inor_
minored10310103m_inored
minors85117103m_inors
mire66748233m_i__re
misdoer1048633misdoer
misdone10310863misdone
mitre75522423m_i_tre
mode75840303mo_d__e
modern939523mo_dern
moderne1037123mo_derne
modioli1045483modioli
modiste1039283modiste
module93011033mo_dule
moiler84017263moiler_
moilers93615203moilers
moira71012023moi__ra
moires8915633moi__res
moister94015373moister
moisture1046653moisture
molder93819273molder_
moldered1237173moldered
molders103315553molders
moldier103110033moldier
monde85723143mond__e
mondo85721233mondo__
mondos95217333mondo_s
mongoe94214983mongo_e
monitor9310723monitor_
monitored1245583monitored
monitors10310823monitors
monitory1347853monitory
moodier103212203moodier
moor66628553mo__or_
moored93814173mo__ored
moors74923143mo__ors
moory105115793mo__ory
moose76327193mo__ose
mopoke1436633mo_poke
more67154523m___ore
morose85116243mo_rose
motor75317293mo_tor_
motored1039933mo_tored
motors84616603mo_tors
nodose738883no_dose
noisome947973noisome
noncore9411953noncore
odor55718093_o_dor_
odored8399223_o_dored
odors64514283_o_dors
omnivore1342703omnivore
oospore939013oospore
ordure756813_ordure
pandore10411853pandore
rondure837313rondure
soilure736233soilure
sordor7310223sordor_
sordors8310013sordors
voider103611553voider_
voiders11279823voiders
woodlore1245103woodlore

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 Limit134027846.45020779.4
3Display Results84840.0332545.5
 (SQL Overall)178691846.88925938.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.