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

157 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
whams13551564(None) 
chams126028501chams
hams96446131_hams
shams105829411shams
wham125321691wham_
whamo135511261whamo
whaps135115161whaps
whats117718991whats
whims134515331whims
bams87044452_bams
beams95328172beams
blams95023852blams
cams87047282_cams
chads116122232chads
chais107530312chais
cham115532312cham_
champ145017962champ
champs154915682champs
chaos105622862chaos
chaps125326062chaps
charms135218832charms
chars105936632chars
chasm125518792chasm
chasms135513142chasms
chats105730092chats
chaws135022462chaws
chays135319742chays
chums125015832chums
clams95127672clams
crams96229152crams
dams77444372_dams
dhaks13479702dhaks
dhals95415442dhals
drams86025832drams
exams14199082exams
flams105125012flams
foams105017952foams
gams76648882_gams
ghats95818612ghats
glams85822932glams
grams85327312grams
haems105517012_haems
haes77651022_haes
hags86740842_hags
hahs108333362_hahs
halms105225212_halms
ham86363282_ham_
hame97043132_hame
hames106138702_hames
haps96443462_haps
harms106829012_harms
has67372652_ha_s
hats76858252_hats
haws106439442_haws
hays106138072_hays
hems95534942_hems
hims95230972_hims
hums96831422_hums
ihrams1137172ihrams
imams91511102imams
jams135231072_jams
khafs15648842khafs
khans124615172khans
khats125316012khats
lams66552262_lams
loams75619862loams
ogams84112682ogams
oghams1245852oghams
ohms95514032oh_ms
pams85641762_pams
prams96125512prams
rams65950772_rams
reams75729622reams
roams74919612roams
scams94423972scams
seams75731662seams
shads95124482shads
shags95123862shags
shahs115919512shahs
sham96436352sham_
shamas113717932shamas
shame105726702shame
shames114726222shames
shamos114216982shamos
shamus114112812shamus
shawms14579562shawms
shaws116226262shaws
shays116021432shays
shims104422542shims
slams74927902slams
spams94922192spams
tams67247932_tams
teams75726512teams
tharms115712242tharms
thaws116515462thaws
trams75327672trams
wabs97337232w_abs
wads87343142w_ads
waes76048602w_aes
wags86140552w_ags
wame95035482w_ame
wames106432802w_ames
wamus105514682w_amus
wans76452262w_ans
waps96642082w_aps
warms107726852warms
wars78659802w_ars
was68767562w_a_s
wats77555882w_ats
waws106834902w_aws
ways107737952w_ays
weals85428742weals
weans85326742weans
wears86030302wears
wha96422072wha__
whack174813022whack
whacks184610482whacks
whale115517432whale
whales124716942whales
whammo16405192whammo
whammy19375292whammy
whang124813382whang
whangs13439722whangs
whap125119642wha_p
wharf14315822wharf
wharfs1546372wharfs
what105434072wha_t
whaup13458882whaup
whaups14405752whaups
wheals124512522wheals
wheats125013222wheats
whelms14377572whelms
whens114618762whens
whets115019612whets
whews145114492whews
wheys145911552wheys
whids125413982whids
whigs125612642whigs
whim126220522whim_
whimsy17375222whimsy
whins114922332whins
whips134917082whips
whirs115218092whirs
whits115923822whits
whom127018172whom_
whomp155011322whomp
whomps16457602whomps
whomso1434132whomso
whops135013932whops
whump154910042whump
whumps16427092whumps
whups134210002whups
whys137011662wh_ys
woads94818442woads
worms105320752worms
wraps105617152wraps
yams95330732_yams

Search took 4 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 Limit538001573.36016011.9
3Display Results1571570.0931688.2
 (SQL Overall)1786911573.54650392.3
 
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.