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

121 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
swain8491905(None) 
sain45551291s_ain
slain54923571slain
stain55727941stain
swail86217161swail
swains94513951swains
swan76631311swa_n
twain86313621twain
wain75840201_wain
again65218122again
ain37579092__ain
amain74922912amain
atwain937812atwain
await85524492await
blain75421792blain
brain76229382brain
cain65643912_cain
chain105723672chain
drain65222892drain
elain55324702elain
fain75840562_fain
gain56042162_gain
grain65126252grain
hwan105716892hwa_n
kain85334292_kain
lain46146282_lain
main65345522_main
pain65647242_pain
plain74823302plain
rain46251732_rain
rawin85521472rawin
sabin74924952sabin
said55742112s_aid
sail45447162s_ail
sains55639972s_ains
saint55147072s_aint
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savin84625082savin
sawing104323812sawing
sawn75428162s_awn
scan65530452sca_n
serin55434442serin
sewan85921292sewa_n
shairn9269062shairn
sharn84823702sharn
shawn116417612shawn
shin75634312s_hin
sin36265892s__in
skein94814412skein
skin85927532s_kin
snail57020202snail
sozin14514542sozin
spail74921552spail
spait75631602spait
span65234662spa_n
spavin114210652spavin
spawn107811712spawn
spin66231302s_pin
sprain83614862sprain
staid66722082staid
staig65519642staig
stains64923652stains
stair54719942stair
statin63921472statin
stein54620542stein
strain64919572strain
swab96825312swa_b
swabs105817272swabs
swag87526732swa_g
swage94919562swage
swaging124210632swaging
swags94921252swags
swails94913122swails
swale85221592swale
swam96329982swa_m
swami105614522swami
swamis114212292swamis
swamp125015322swamp
swamy136714402swamy
swang95519722swang
swank125318232swank
swanny12336822swanny
swans84625012swans
swap95925432swa_p
swaps104819202swaps
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218842swarm
swart86234642swart
swash116316752swash
swat77244442swa_t
swath115920382swath
swats85726862swats
sway107128232swa_y
swaying143610642swaying
sways115518462sways
swig85818022sw_ig
swim96221402sw_im
swine85625302sw_ine
swing96124842sw_ing
swink125116352sw_ink
swoon85014782swoon
sworn86115312sworn
swoun84811492swoun
tain45548072_tain
train56529112train
twains95811182twains
twin76023082tw_in
vain75233002_vain
waif105836752_waif
wail75238822_wail
wains86930872_wains
wair75830052_wair
wait75553692_wait
wan66761942_wa_n
warn75239322_warn
whin105225692_whin
win66456292_w_in

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.296603685.8
2DLD Change Limit538001211.46636698.5
3Display Results1211210.0333666.7
 (SQL Overall)1786911211.79599549.3
 
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.