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

215 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
wapiti113836(None) 
wapitis1236471wapitis
capita102913772capita
rapini84714682rapini
wait75553692wa_it_
waits88333522wa_its
wakiki1233462wakiki
aalii5316133aali_i
acini75718983_acini
adit56443653_adit_
adits66523713_adits
agita6315423_agita
ait38093903_a_it_
aits46355533_a_its
alibi7514233_alibi
alit46155693_alit_
amici94217393_amici
amity10416093_amity
animi74016663_animi
anti45536363_a_nti
apian75018333_apian
aping87327233_aping
apish105116633_apish
aplite8316393_aplite
aplitic11311743_aplitic
apt57352543_ap_t_
await85524493await_
awaits96411953awaits
axite125218253_axite
bait66556003ba_it_
baith108023133ba_ith
baits76630583ba_its
barite84224813barite
cacti9318643ca_cti
capias10318353capias
capital112311523capital
capitol11258283capitol
capiz18514563capi_z
capote10315733capote
caput9823983caput_
casini84615863casini
casita82913703casita
cavity14310013cavity
chapati14118023chapati
cubiti10399083cubiti
dacite91115883dacite
davit93424593davit_
davits104012363davits
faith115620853fa_ith
fajita1635923fajita
gait56150193ga_it_
gaits65726013ga_its
gaping105618923gaping
habit103027023habit_
habits113014653habits
hadith13312063hadith
halite93624233halite
haplite12310703haplite
haptic13511893haptic
jaditic1746703jaditic
japing165013573japing
kabiki1134783kabiki
kaput11717063kaput_
kaputt1268003kaputt
laith85722103la_ith
laity85318903la_ity
lapilli945643lapilli
lapin75222923lapi_n
lapins84520683lapins
lapis76223153lapi_s
lati46438273la__ti
laxity1637273laxity
maloti8313213maloti
manito8518693manito
manitu8315823manitu
panini8314273panini
papism122211513papism
papist102618743papist
papistic1448733papistic
papists112110453papists
pappi84810893pap_pi
papyri1334903papyri
parity114719873parity
periti8319953periti
piki106520563__piki
pili66130353__pili
pipit95224873pipit_
pipits104713063pipits
pit56471923__pit_
pita65436433__pita
pith95432693__pith
pits66348743__pits
pity96031933__pity
radii64016413radi_i
raita54623073ra_ita
rapid86422033rapi_d
rapids94913893rapids
rapier84019993rapier
rapine85023083rapine
raping94829853raping
rapist82520673rapist
rapists92510753rapists
rappini11347573rappini
rapt67245313rap_t_
rarity93615493rarity
ratite65022423ratite
saith85826553sa_ith
samite83020603samite
sanity9316203sanity
sapid84720933sapi_d
sapota8310213sapota
sapote8314363sapote
sati45539333sa__ti
seniti64317223seniti
sopite84917713sopite
spait75631603spait_
spaits85017473spaits
spit65545083_spit_
spite75430663_spite
spits74429553_spits
spitz166017973_spitz
tacit76333673tacit_
tahini939893tahini
tapeta8310693tapeta
taping94222393taping
tapir75917063tapi_r
tapirs84113173tapirs
tapis75028863tapi_s
taxite13511303taxite
taxitic1637093taxitic
titi47130623__titi
uppity1335103uppity
vanity12311933vanity
vapid115614283vapi_d
wadi86228173wa__di
wadies105121203wadies
wading114619533wading
wadis95223963wadi_s
waft106139003wa_ft_
wafts116920553wa_fts
waging114318383waging
wahine123813013wahine
waif105836753wa_i_f
waifs115719873wa_ifs
wail75238823wa_i_l
wails86631483wa_ils
wain75840203wa_i_n
wains86930873wa_ins
wair75830053wa_i_r
wairs86424063wa_irs
waist86132383wa_ist
waists97415453waists
waited103819773wa_ited
waiter94321253wa_iter
waiting113618953wa_iting
waive114214603wa_ive
wakikis1342623wakikis
waking144821383waking
walies95324523walies
waling104525303waling
waltz17615473wa_ltz
wampish1777293wampish
wanier93920683wanier
waning103623803waning
wanion93213063wanion
want76156173wa_nt_
wants87932213wa_nts
wap86553373wap___
wapped144416473wapped
wapping153514603wapping
waps96642083wap__s
warier93722893warier
warily122915093warily
waring105029443waring
warmth1477933warmth
warpath1545203warpath
warping133715183warping
wart77866083wa_rt_
warts814840403wa_rts
warty119323823wa_rty
wasabi1154643wasabi
waspier12259053waspier
waspily1535513waspily
waspish1586923waspish
wast75655853wa_st_
waste86125053wa_ste
wasts87433673wa_sts
wat67378923wa__t_
wats77555883wa__ts
watt75545413wa__tt
watts86923093wa_tts
wavier124613083wavier
wavies125019843wavies
wavily15219483wavily
waving134018203waving
waxier16439903waxier
waxily19218413waxily
waxing174215283waxing
wept95635053wep_t_
whipt135317423whipt_
whit104834173w_hit_
white114920303w_hite
whits115923823w_hits
whity145513473w_hity
wiping123916713wiping
wit66563773w__it_
wite75443273w__ite
with105730473w__ith
wits76044873w__its
wraith1258603wraith
wrapt105123183wrap_t_
writ75537913w_rit_
write85522833w_rite
writs86624383w_rits
ziti136022373__ziti

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162154.90622975.1
3Display Results2152150.0802687.5
 (SQL Overall)1786912155.12634859.7
 
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.