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

85 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
moola7511703(None) 
mola66035631m_ola
mool67533861mool_
moolah11409191moolah
moolas83615591moolas
mools76027171mools
bola66035562_bola
boyla102912362boyla
chola104718032chola
coala77521122coala
cola66541392_cola
cool66940492cool_
cools75632632cools
cooly105525422cooly
dobla84913642dobla
dooly94821802dooly
doula65717772doula
fool75330592fool_
fools86824202fools
holla84918492holla
hooka125513902hooka
hooly115022222hooly
hoopla1147632hoopla
koala95112212koala
kola85124972_kola
loofa85912812loofa
moa57249182m_o_a
mocha1249922mocha
modal85919242modal
moil65534092moil_
moils76125752moils
moira71012022moira
mol56654592m_ol_
molal75120342m_olal
molar75223092m_olar
molas75132092m_olas
mold76034332m_old
mole66251832m_ole
moll66735702m_oll
mollah11319452mollah
molls75129782molls
molly105222492molly
mols65948572m_ols
molt66356162m_olt
moly96031912m_oly
momma85111052momma
moo58460512moo__
mooch125313612mooch
mood76332062moo_d
moods85224622moods
moody115017492moody
mooed85123982mooed
moolahs12347382moolahs
mooley11311632mooley
moon67140812moo_n
moons75331002moons
moony104818272moony
moor66628552moo_r
moors74923142moors
moory105115792moory
moos66051302moo_s
moose76327192moose
moot67653622moo_t
moots75831662moots
mora66641272m_ora
moral75533432moral
morula8710472morula
mould86015752mould
moult74728722moult
moviola1244822moviola
moxa136917742m_oxa
mulla74317112mulla
myoma1239272myoma
olla44821172_olla
pool65835952pool_
pools74427702pools
sola45541862_sola
tola45236332_tola
tool46735682tool_
tools55325242tools
viola85915542viola
voila84813942voila
wool76427372wool_
wools84421462wools
wooly114417672wooly

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.343520965.0
2DLD Change Limit53800851.57634137.1
3Display Results85850.0165312.5
 (SQL Overall)178691851.93592346.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.