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

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

162 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
handsets1225834(None) 
handsels12317251handsels
handset113016821handset_
handers114224332hand_ers
handiest123417782handiest
handlers124014142handlers
handles114020652handle_s
handless123512062handless
handouts1238232handouts
handsaws1545872handsaws
handsel11308722handse_l
handsewn1543622handsewn
hansels104011662han_sels
hanses95022632han_se_s
hardset113415832hardset_
headsets1236052headsets
mindsets1135682mindsets
wadsets1136442wa_dsets
angsts738863_angs_ts
anises64826703_anise_s
anklets114310413_anklets
anuses66218773_anuse_s
assets65617663_a_ssets
avosets1036663_avosets
backsets1638853backsets
banders104324563band_ers
bandies104124863bandie_s
bandits103814793band_its
bandsaws1444623bandsaws
bannets94013843ban_nets
banquets1935433banquets
bassets96414823ba_ssets
bonesets1036843bonesets
cadets96316513ca_d_ets
candies104125613candie_s
candlers114214103candlers
candles104422343candle_s
chandlers15387673chandlers
damndests1392793damndests
danders93921183dand_ers
dandies94121443dandie_s
dandiest103415033dandiest
dandlers103912053dandlers
dandles94218533dandle_s
darndests1183143darndests
fanjets1734803fan_jets
gadgets10348683ga_dgets
ganders93521703gand_ers
gannets83811443gan_nets
gantlets9308903gantlets
haddest122711993haddest_
hades96035113ha_d_e_s
hadjees18356383ha_djees
hadjes175210403ha_dje_s
hadst93220223ha_ds_t_
haets86525123ha___ets
haffets1636053ha_ffets
hairnets1195633hairnets
hamlets123211403ha_mlets
hanapers1346963hanapers
hances115621283han_ce_s
handaxes1938403handaxes
handbags15116363handbags
handbaskets2151533handbaskets
handbell14114523handbell
handbells1594363handbells
handcars1437623handcars
handcarts1545533handcarts
handed114919983hand_e_d
hander104526433hand_e_r
handfast1546733handfast
handfasts1644593handfasts
handfuls15115753handfuls
handguns1344363handguns
handheld1644463handheld
handhelds1743763handhelds
handier113817443handie_r
handiness132110933handiness
handle104219293handle__
handled124114533handle_d
handler113516163handle_r
handlist12311333handlist
handlists1347133handlists
handoffs1844733handoffs
handout11314103handout_
handovers16136183handovers
handpress1544033handpress
hands95327383hand___s
handsaw1435533hands_aw
handseled1444403handseled
handsful1544083handsful
handsome1447603handsome
handsomest1654263handsomest
hangers113120813han_gers
hangnest12311413hangnest
hangnests1344543hangnests
hangouts1236183hangouts
hankers144218133han_kers
hankies143617763hankie_s
hansas94616043han_s_as
hanse85722793han_se__
hansel95214373han_se_l
hansoms12238523han_soms
hantles104117513hantle_s
hants86335403han___ts
hardens113815023hard_ens
hardest113118413hardest_
hardhats1546833hardhats
hardies114923233hardie_s
hardiest123416343hardiest
hardness122411083hardness
harslets1137833harslets
harvests14246173harvests
haslets102510863ha_slets
hassels104311023ha_ssels
hastes95727073ha__stes
hatchets163310383hatchets
hausens1077633ha_usens
hawsers13409483ha_wsers
hawses125113993ha_wse_s
headset11312603headset_
hinders113718503hind_ers
hindguts1343013hindguts
hondles113614523hondle_s
hundreds1344003hundreds
insets64016133_in_sets
lancets93411163lan_cets
landers84026223land_ers
landlers94312833landlers
landless94011173landless
languets987243languets
manchets15269573manchets
mandates11314093mandates
mandrels1137313mandrels
manses84225513man_se_s
mantlets104611203mantlets
mindset10313343mindset_
nailsets834553nailsets
onsets64013543_on_sets
pandects1335843pandects
panders103423743pand_ers
pandies104224503pandie_s
pandits103914213pand_its
randies84225663randie_s
randiest93418773randiest
rundlets9307363rundlets
sanders84025943sand_ers
sandiest93218693sandiest
sandless93212343sandless
sandlots938293sandlots
sandpits1146843sandpits
sanseis73011603san_seis
shandies122714113shandie_s
sunsets72911573sun_sets
syndets1136113synd_ets
tandems1037633tand_ems
tanists7313663tanis_ts
tassets75012773ta_ssets
unsets64116163_un_sets
wadset10314303wa_dset_
wanders114221333wand_ers
zanders173015793zand_ers

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621628.34317519.1
3Display Results1621620.0802025.0
 (SQL Overall)1786911628.85920170.6
 
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.