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

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

78 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
morro7321695(None) 
morros83714671morros
morrow113510091morrow
borrow114310732borrow
burro75018492burro
dobro84412212dobro
dorr56627722dorr_
dorrs65520592dorrs
fordo97218652fordo
forgo94418332forgo
horror988722horror
lorry86315672lorry
macro94718172macro
marron83717542marron
marrow112812612marrow
marry104821692marry
merry104721492merry
metro74718802metro
micro94715992micro
mirror848002mirror
moira71012022moira
moire71017322moire
mojo136917222mo_jo
molto75619602molto
mondo85721232mondo
mongo810122412mongo
mono66036722mo_no
moo58460512mo__o
moor66628552moor_
moors74923142moors
moory105115792moory
mor56855002mo_r_
mora66641272mo_ra
morae75831192morae
moral75533432moral
moras76438782moras
moray105423792moray
more67154522mo_re
morel75729092morel
mores76249642mores
morion86217732morion
morn66237562mo_rn
morns75527442morns
moron76925422moron
morph121712512morph
morpho13158442morpho
morrion959002morrion
morris83814732morris
morrows12318722morrows
mors65950062mo_rs
morse76032702morse
mort66758832mo_rt
morts75533562morts
mosso74715182mosso
motor75317292motor
motto76119512motto
mourn77215012mourn
mozo157719742mo_zo
mucro94513722mucro
murr65225132murr_
murra74519082murra
murre74821072murre
murrs75521302murrs
murry105120232murry
myrrh1337092myrrh
ordo54622362_ordo
orra46120722_orra
orzo134516782_orzo
porno75120652porno
sorgo64719722sorgo
sorrow9339442sorrow
sorry84618252sorry
torero6313202torero
toro48045682to_ro
torr45630902torr_
torrs53923562torrs
torso56922142torso
worry116114332worry

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit53800781.47036598.6
3Display Results78780.0302600.0
 (SQL Overall)178691781.81098724.3
 
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.