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

108 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
swains9451395(None) 
sains55639971s_ains
stains64923651stains
swails94913121swails
swain84919051swain_
swans84625011swa_ns
twains95811181twains
wains86930861_wains
ains46158882__ains
awaits96411952awaits
blains84516372blains
brains85125472brains
cains75334302_cains
chains114819702chains
drains73719402drains
elains64919852elains
gains65729512_gains
grains74223092grains
kains96125642_kains
mains75635092_mains
pains75138282_pains
plains85019592plains
rains55140232_rains
rawins95617622rawins
sabins85521972sabins
saids65328852s_aids
sails55738102s_ails
sain45551292s_ain_
saint55147072s_aint
saints65122422s_aints
sans45153352s_a_ns
sarins63932622sarins
sasins64923102sasins
satins64930482satins
savins93923132savins
sawing104323812sawing
scans74625102sca_ns
serins64029672serins
sewans95215902sewa_ns
shairns10276782shairns
sharns95516982sharns
shins85131042s_hins
sins46755272s__ins
skeins103911902skeins
skins94723462s_kins
slain54923572slain_
snails64816652snails
sowans94215892sowa_ns
sozins15510782sozins
spails84817822spails
spaits85017472spaits
spans74528732spa_ns
spavins12419322spavins
spawns11577922spawns
spins75327982s_pins
sprains93013592sprains
staigs75414812staigs
stain55727932stain_
stairs65416332stairs
statins73719772statins
steins64818342steins
strains74218152strains
swabs105817272swa_bs
swages104417072swages
swaging124210632swaging
swags94921252swa_gs
swail86217162swai_l
swainish1444752swainish
swales93920762swales
swamies123712062swamies
swamis114212292swamis
swamps135910262swamps
swan76631312swa_n_
swang95519722swa_ng
swank125318232swa_nk
swanks134811562swanks
swanny12336822swanny
swaps104819202swa_ps
swards105415132swards
swarfs125612062swarfs
swarms116112162swarms
swaths125312642swaths
swats85726862swa_ts
swaying143610642swaying
sways115518462swa_ys
swigs96213662sw_igs
swims105514142sw_ims
swine85625302sw_ine
swing96124842sw_ing
swings104714452sw_ings
swink125116352sw_ink
swinks134610652sw_inks
swiss86712902sw_iss
swoons94511142swoons
swouns9358242swouns
tains54936322_tains
trains64725342trains
twain86313622twain_
twins85118982tw_ins
waifs115719872_waifs
wails86631482_wails
wain75840192_wain_
wairs86424062_wairs
waits88333522_waits
wans76452262_wa_ns
warns87231002_warns
whins114922332_whins
wins75949172_w_ins

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 Filter178691825510.1061685764.2
2DLD Change Limit825511083.42324116.6
3Display Results1081080.0333272.7
 (SQL Overall)1786911083.56250165.9
 
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.