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

105 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
taunt5553228(None) 
aunt46553651_aunt
daunt65929081daunt
gaunt65430401gaunt
haunt85229131haunt
jaunt125025271jaunt
taint55542281taint
taunts65715661taunts
taut47048961tau_t
vaunt85925311vaunt
ant37270782_a_nt
aunts55227632_aunts
aunty85919812_aunty
avaunt959602avaunt
blunt75525022blunt
brunt75728752brunt
bunt65850852_bunt
cant66362022ca_nt
chaunt11613492chaunt
count74932052count
cunt66243672_cunt
daunts75014082daunts
daut56443562dau_t
dunt55746872_dunt
faint85837062faint
fault85428312fault
faun76226622faun_
fauna84816512fauna
fauns84516752fauns
flaunt9712912flaunt
fount84727032fount
gault65128482gault
gaun56427712gaun_
grunt65523542grunt
haint85436322haint
hant75461582ha_nt
haunts95614392haunts
haut75949732hau_t
hunt76445492_hunt
jaunts137511882jaunts
jaunty16388512jaunty
lunt46148842_lunt
maun65727202maun_
maund85515442maund
maut65448442mau_t
mount74128062mount
paint75443692paint
pant66061252pa_nt
punt65747202_punt
quant143624812quant
rant45864672ra_nt
runt46647982_runt
saint55147072saint
sault55834962sault
sauna54117552sauna
shunt85226502shunt
strunt64918912strunt
stunt55328172stunt
tabun75914372tabun_
tabuns8489222tabuns
tacet75840022tacet
tacit76333672tacit
tact67349032ta_ct
tain45548072tain_
tains54936322tains
taints64520532taints
talent6323322talent
tan37167562ta_n_
tang56138662ta_ng
tank85134012ta_nk
tans46154812ta_ns
tanto55724942ta_nto
tarn46842722tarn_
tarns56433952tarns
tarot55943932tarot
tart47566182ta_rt
tat37690292ta__t
tau36856902tau__
taught104312222taught
taunted84310962taunted
taunter73111452taunter
tauon54816582tauon
tauons63412672tauons
taupe7314162taupe
taus46342732tau_s
tauts56125512tauts
tawny114713652tawny
tent46159862t_ent
thunk124911852thunk
tint46758862t_int
tout46753822tou_t
truant6315782truant
trunk94713042trunk
trust55426852trust
tuft76929512t_uft
tun35845192t_un_
tuna45127842t_una
tune45635862t_une
tung55328162t_ung
tuns45138662t_uns
tut36758092t_u_t
vault85823762vault
vaunts95212622vaunts
vaunty12409062vaunty
want76156162wa_nt

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 Limit538001051.73630990.8
3Display Results1051050.0303500.0
 (SQL Overall)1786911051.85996122.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.