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

96 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
hent76656381_hent
shent85933501shent
went76051871w_ent
wheat114924571wheat
when105723041when_
whens114618761whens
whet105133781whe_t
agent65829642agent
ament76036542ament
anent54931842anent
bent67759912_bent
blent76230952blent
brent75734132brent
cent67451012_cent
chant105932692chant
cheat105732452cheat
chert105232102chert
chest104926142chest
dent57158412_dent
event85924442event
gent56954392_gent
hant75461592_hant
heat77061422_heat
heft106736292_heft
hen67555272_hen_
hens75642572_hens
hents87330742_hents
hest75950772_hest
het67674312_he_t
hint77455742_hint
hunt76445492_hunt
kent86846962_kent
khet116328622khe_t
lent46360532_lent
pent66559072_pent
rent46661242_rent
scent75831622scent
sent46963012_sent
sheet84836962sheet
shend94719972shend
shunt85226512shunt
spent75532832spent
stent55634512stent
tent46159862_tent
theft114118132theft
then78429692then_
thens85921832thens
vent76049052_vent
want76156172w_ant
ween75835462ween_
weens85224052weens
weeny115316162weeny
weest85026772weest
weet75254152w_eet
weft105435012w_eft
welt75547862w_elt
wen66249602w_en_
wend85330452w_end
wens76337932w_ens
wept95635052w_ept
wert79749822w_ert
west75748082w_est
wet65966622w_e_t
whang124813382whang
what105434072wh_at
wheal115716182wheal
wheats125013222wheats
whee105429592whe_e
wheel115515332wheel
wheen115016052wheen
wheens124610612wheens
wheep136214352wheep
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
whenas124610462whenas
whence14187922whence
where117019422where
whets115019612whets
whew137618782whe_w
whews145114492whews
whey135018712whe_y
wheys145911552wheys
whin105225692whin_
whine116022812whine
whins114922332whins
whiny144915572whiny
whipt135317422whipt
whist115322952whist
whit104834172wh_it
whort114623692whort
wisent93516342wisent
wont75842502w_ont
wren78221682wren_
wrens85016242wrens
wrest84925432wrest

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.313570897.8
2DLD Change Limit53800961.53035163.4
3Display Results96960.0332909.1
 (SQL Overall)178691961.87695251.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.