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

83 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
loamy10591334(None) 
foamy135313201foamy
loam65630481loam_
loams75619861loams
beamy126218572beamy
bloomy134510112bloomy
boomy125421822boomy
coaly105521592coaly
commy144712642commy
doomy116018262doomy
dormy115817462dormy
flamy135217472flamy
floaty124210942floaty
foam97127172foam_
foams105017952foams
gamy105427532_gamy
gleamy12398112gleamy
gloam86015942gloam_
gloams95210662gloams
gloomy12528762gloomy
hoagy124710472hoagy
hoary114516762hoary
homy126623222ho_my
lacy95829632l_acy
lady86527152l_ady
laky116725822l_aky
lam57666712l_am_
lama66635292l_ama
lamb86832142l_amb
lamby125114842l_amby
lame66849292l_ame
lamp86233822l_amp
lams66552262l_ams
lay68865352l_a_y
lazy166423072l_azy
leady95618602leady
leafy116316212leafy
leaky125217722leaky
leary85927382leary
leavy115715772leavy
limy95727712l_imy
llama799892llama
loach105116362loach
load56730602loa_d
loads65323372loads
loaf76734902loa_f
loafs85616992loafs
loamed94414612loamed
loan47436452loa_n
loans56026462loans
loath84918602loath
lobby125113912lobby
lofty115813302lofty
loggy105714192loggy
logy87025782lo_gy
lolly85120662lolly
looby108115622looby
looey84822912looey
loom67035052loom_
looms75124642looms
loony86918962loony
loopy105316642loopy
loppy125911662loppy
lorry86315662lorry
lory75931712lo_ry
lossy85214642lossy
louma76213632louma
loury85716752loury
lousy84617082lousy
lowly114113332lowly
mommy114010752mommy
oaky116419952_oaky
oogamy1235632oogamy
pommy14449862pommy
roam67132412roam_
roams74919612roams
roomy107118062roomy
seamy105921272seamy
soapy106114782soapy
swamy136714402swamy
toady96814342toady
tommy124712232tommy
wormy137514252wormy

Search took 3 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.0931921408.6
2DLD Change Limit53800831.93627789.3
3Display Results83830.0332515.2
 (SQL Overall)178691832.06286659.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.