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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

178 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
worms10532075(None) 
corms95626221corms
dorms85723831dorms
forms105327051forms
gorms85619591gorms
norms76019301norms
warms107726851warms
words95425071words
works125621901works
worm96129481worm_
wormy137514251wormy
worts88631181worts
arms66137492_arms
barms96128462barms
berms95323662berms
beworms1437912beworms
booms95427122booms
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
cords86030622cords
cores76361852cores
corks116028272corks
corm85735372corm_
corns76034762corns
corps95927042corps
cors66656442cor_s
derms85022892derms
deworms1338012deworms
doms76239572do_ms
dooms85321342dooms
dorks105724442dorks
dorm76834622dorm_
dormy115817462dormy
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doums85417642doums
farms106324952farms
firms105217422firms
foams105017952foams
forams115115912forams
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
form95836872form_
forme105225992forme
formes114623712formes
forts86034452forts
forums114611842forums
germs85118872germs
gores65740372gores
gorm75529392gorm_
gorps85316992gorps
harms106829012harms
herms105626432herms
holms105117802holms
horas86333092horas
horns86125332horns
jorams154810532jorams
jorums15408092jorums
koras95927112koras
korma115913072korma
kormas124511232kormas
kors85933012kor_s
loams75619862loams
looms75124642looms
lords64923502lords
lores55045402lores
loris55329152loris
moms86539482mo_ms
moras76438762moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
noms65636402no_ms
noris54928272noris
norm66429812norm_
ohms95514032_ohms
oms56337512_o_ms
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
orts46538332_orts
perms95524512perms
poems95715552poems
poms87037742po_ms
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
proms95426402proms
roams74919612roams
roms67038962ro_ms
rooms75324682rooms
soms66239372so_ms
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
storms85814612storms
swarms116112162swarms
swords104510792swords
terms75523472terms
toms68343492to_ms
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
wards97734402wards
wares88250582wares
warks127932402warks
warm95935672warm_
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
whams135515642whams
whims134515332whims
whores125617102whores
whorls124410162whorls
whorts125111432whorts
wires86034912wires
woads94818442woads
woes76440662wo_es
wogs86531402wo_gs
woks116224902wo_ks
wolds95420182wolds
wolfs116214162wolfs
womb117022232wo_mb
wombs125813342wombs
wonks124818342wonks
wons74942042wo_ns
wonts87621542wonts
woods95723032woods
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802wo_os
wops96634152wo_ps
word89832002wor_d
wordy126916162wordy
wore77144672wor_e
work115528842wor_k
world96915362world
worlds10568732worlds
wormed124314302wormed
wormer114514912wormer
wormers124012572wormers
wormil1138042wormil
wormils1236732wormils
wormish1537162wormish
worn75631752wor_n
worry116114332worry
worse86525262worse
worses95522952worses
worst86330132worst
worsts96014332worsts
wort76654752wor_t
worth117120522worth
worths127812892worths
wos66953532wo__s
wots76342892wo_ts
wows104633492wo_ws
yores85031322yores
zooms164415522zooms
zoris145320012zoris

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.0931921408.6
2DLD Change Limit538001781.54634799.5
3Display Results1781780.0463869.6
 (SQL Overall)1786911781.685106048.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.