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

111 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
scald8481812(None) 
scad75725771sca_d
scalds94813691scalds
scale74629141scale
scaled94822441scaled
scall74420371scall
scalp95217981scalp
scaly104718721scaly
scold85414861scold
skald104210171skald
acold86214922acold
bald76432902_bald
cad67456362_ca_d
caid77837532_caid
calf96339562_calf
calk105527662_calk
call66838672_call
calm85032362_calm
calo64936442_calo
calx135722792_calx
card710245872_card
cauld85318442_cauld
clad76225822_clad
cold77338772_cold
sad47459202s_a_d
said55742112s_aid
sal36462882s_al_
salad65321832s_alad
sale44959702s_ale
sall44544682s_all
salp64534092s_alp
sals46851672s_als
salt45758522s_alt
sand55338472s_and
sard55344242s_ard
scab85926712sca_b
scabs94818642scabs
scads85419962scads
scag76626892sca_g
scags85520972scags
scalade10359262scalade
scalado10276472scalado
scalar83612432scalar
scalded11409762scalded
scaldic1235942scaldic
scaler84321602scaler
scales84529312scales
scalls84218202scalls
scalped124411992scalped
scalps104315232scalps
scam85932352sca_m
scamp115717312scamp
scams94423972scams
scan65530452sca_n
scans74625102scans
scant79735072scant
scape96921842scape
scaped115519552scaped
scar66434202sca_r
scare75334462scare
scared95227292scared
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scart76139772scart
scary105222592scary
scat65848372sca_t
scats75930602scats
scatt76030092scatt
scaup95515992scaup
scaur75814902scaur
scend85516292scend
scolds95011232scolds
scrod85115062scrod
scud76221282sc_ud
sculk115112462sculk
scull75315762scull
sculp95314842sculp
seal45654372seal_
sealed74328362sealed
seals54839692seals
shad86230912sha_d
shale85332832shale
shaled105023952shaled
shall85024052shall
shalt85534492shalt
shaly114322862shaly
shard96125962shard
sial45938832sial_
sialid7314942sialid
sials54227242sials
sild55030582s_ild
skalds11437832skalds
small74016262small
smalt74729332smalt
sold54837412s_old
spaed85522272spaed
spale74929212spale
spall74919302spall
staid66722082staid
stale55637102stale
staled74728102staled
stalk94518002stalk
stall54722352stall
stand65923282stand
swale85221592swale
sward94221462sward
weald95615022weald
woald94813072woald
yald86920612_yald
yclad11246382yclad

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 Limit538001111.56334421.0
3Display Results1111110.0166937.5
 (SQL Overall)1786911111.672106872.6
 
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.