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

153 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
whaps13511516(None) 
chaps125326061chaps
haps96443461_haps
waps96642081w_aps
whams135515641whams
whap125119641whap_
whats117718991whats
whaups14405751whaups
whips134917081whips
whops135013931whops
whups134210001whups
wraps105617151wraps
ataps76414832ataps
baps86040842_baps
caps87147892_caps
chads116122232chads
chais107530312chais
champs154915682champs
chams126028502chams
chaos105622862chaos
chap114928492chap_
chape125221142chape
chapes135421872chapes
chapt125827642chapt
chars105936642chars
chats105730092chats
chaws135022462chaws
chays135319742chays
cheaps134613682cheaps
chips125721252chips
chops125019872chops
claps95626182claps
craps95328642craps
daps77239162_daps
dhaks13479702dhaks
dhals95415442dhals
flaps105621382flaps
fraps105620552fraps
gaps76042972_gaps
ghats95818612ghats
haes77651022_haes
hags86740842_hags
hahs108333362_hahs
hams96446132_hams
hap87360052_hap_
harps105926872_harps
has67372652_ha_s
hasp96627292_hasp
hasps105114642_hasps
hats76858252_hats
haws106439442_haws
hays106138072_hays
heaps105223222heaps
hips96433712_hips
hops97942632_hops
hyps125418412_hyps
khafs15648842khafs
khans124615172khans
khaph17395962khaph
khaphs18394322khaphs
khats125316012khats
knaps115511172knaps
laps66848872_laps
leaps75522932leaps
maps86141052_maps
naps66238582_naps
neaps75618322neaps
paps86443452_paps
raps66247732_raps
reaps75626192reaps
saps65346372_saps
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shape105125112shape
shapes115124952shapes
sharps115516082sharps
shaws116226262shaws
shays116021432shays
ships105123772ships
shnaps1148082shnaps
shops104222902shops
slaps76025712slaps
snaps74719562snaps
soaps75120712soaps
swaps104819202swaps
taps66050682_taps
thaws116515462thaws
traps75727482traps
wabs97337232w_abs
wads87343152w_ads
waes76048602w_aes
wags86140552w_ags
wans76452272w_ans
wap86553372w_ap_
warps107126422warps
wars78659802w_ars
was68767562w_a_s
wasp95626852w_asp
wasps106714692wasps
wataps11248682wataps
wats77555882w_ats
waws106834902w_aws
ways107737952w_ays
weals85428742weals
weans85326742weans
wears86030302wears
weeps104120562weeps
wha96422072wha__
whack174813022whack
whacks184610482whacks
whale115517432whale
whales124716942whales
wham125321692wha_m
whamo135511262whamo
whang124813382whang
whangs13439722whangs
wharf14315822wharf
wharfs1546372wharfs
what105434072wha_t
whaup13458882whaup
wheals124512522wheals
wheats125013222wheats
wheeps14439952wheeps
whelps14437842whelps
whens114618762whens
whets115019612whets
whews145114492whews
wheys145911552wheys
whids125413992whids
whigs125612642whigs
whims134515332whims
whins114922332whins
whip125521842whip_
whipt135317422whipt
whirs115218092whirs
whits115923822whits
whomps16457602whomps
whoops14487862whoops
whop125520922whop_
whumps16427092whumps
whup125714162whup_
whys137011662wh_ys
wimps125213802wimps
wisps105214182wisps
woads94818442woads
woops104917522woops
wops96634152w_ops
wrap96821972wrap_
wrapt105123182wrapt
yaps95933522_yaps
zaps156826892_zaps

Search took 3 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 Limit538001532.28023596.5
3Display Results1531530.0463326.1
 (SQL Overall)1786911532.63967711.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.