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

89 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
wormy13751425(None) 
dormy115817461dormy
wordy126916161wordy
worm96129481worm_
worms105320751worms
worry116114331worry
army96624182_army
barmy125218762barmy
boomy125421822boomy
borty105522832borty
commy144712642commy
corby125018532corby
corky145221152corky
corm85735372corm_
corms95626222corms
corny106023272corny
cory96941512cor_y
doomy116018262doomy
dorky135518742dorky
dorm76834622dorm_
dorms85723832dorms
dorty96220812dorty
dory85836232dor_y
foamy135313202foamy
foray115023972foray
forby135317672forby
forky156119642forky
form95836872form_
forme105225992forme
forms105327052forms
formyl14276442formyl
forty114824272forty
germy115113662germy
gorm75529392gorm_
gorms85619592gorms
gorsy95915782gorsy
gory86129662gor_y
homy126623222ho_my
horny115619622horny
horsy116318392horsy
korma115913072korma
loamy105913342loamy
lorry86315672lorry
lory75931712lor_y
mommy114010752mommy
moray105423792moray
norm66429812norm_
norms76019302norms
orby97519602_orby
orgy85218002_orgy
pommy14449862pommy
porgy116916122porgy
porky145019332porky
porny106020192porny
roomy107118062roomy
sorry84618252sorry
stormy115510722stormy
tommy124712232tommy
tory75840542tor_y
warm95935672warm_
warmly14228062warmly
warms107726852warms
warty119323822warty
wary106740012war_y
wiry106422832wir_y
womb117022232wo_mb
womby155910092womby
womyn13426362wo_myn
wonky154011772wonky
woody125116882woody
wooly114417672wooly
woozy204410602woozy
word89832002wor_d
words95425072words
wore77144672wor_e
work115528842wor_k
works125621902works
world96915362world
wormed124314302wormed
wormer114514912wormer
wormil1138042wormil
worn75631752wor_n
worse86525262worse
worst86330132worst
wort76654752wor_t
worth117120522worth
worthy15598802worthy
worts88631182worts
wry96524702w_r_y

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 Limit53800892.28323565.5
3Display Results89890.0461934.8
 (SQL Overall)178691892.42273778.3
 
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.