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

116 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
spaits8501747(None) 
spails84817821spails
spait75631601spait_
spats75031381spa_ts
spits74429551sp_its
splits85416411splits
sprits85122531sprits
aits46355532__aits
awaits96411952awaits
baits76630582_baits
epacts105010392epacts
esprits938392esprits
gaits65726012_gaits
kraits104912202kraits
pacts95125802_pacts
paiks114719852_paiks
pails75833062_pails
pains75138282_pains
paints85921832_paints
pairs75325832_pairs
pants76536922_pants
parts77743372_parts
pasts75936502_pasts
pats66460852_pa_ts
pits66348742_p_its
plaits83816472plaits
saids65328852s_aids
sails55738102s_ails
sains55639972s_ains
saints65122422s_aints
saith85826552s_aith
salts55431882s_alts
satis55633682s_atis
scants85219722scants
scarts85321492scarts
scats75930602sca_ts
scatts85914662scatts
seats54844342sea_ts
shafts125411442shafts
shits84731172s_hits
sits45050202s__its
skats94621542ska_ts
skits94721862s_kits
slants64819082slants
slats55436902sla_ts
slits56128852s_lits
smalts85214892smalts
smarts86218002smarts
snails64816652snails
snits54124832s_nits
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spahis11310382spahis
spail74921552spai_l
spales84728102spales
spalls84217342spalls
spams94922192spa_ms
spanks124514122spanks
spans74528732spa_ns
spares84834552spares
sparids103512122sparids
sparks124616362sparks
spars75431542spa_rs
spas67036722spa__s
spasms10418972spasms
spat66548522spa_t_
spate74731582spa_te
spates85028172spates
spavies123012952spavies
spavins12419322spavins
spawns11577922spawns
spays105520512spa_ys
speils84116222speils
speirs85013232speirs
speiss84311642speiss
spelts84614642spelts
spics94123242sp_ics
spies76037622sp_ies
spiks114117472sp_iks
spins75327982sp_ins
spirits94112622spirits
spirts85317132spirts
spit65545082sp_it_
spite75430662sp_ite
spites84127332sp_ites
spitz166017972sp_itz
spivs105114242sp_ivs
splats84817302splats
splints94511742splints
split75729012split_
spoils84614532spoils
sports84619182sports
spots74424112sp_ots
spouts85115112spouts
sprains93013592sprains
sprats85819932sprats
sprigs94814772sprigs
sprints94113772sprints
sprit76736402sprit_
sprite84421772sprite
sprites94220332sprites
spritz174714422spritz
spurts84814972spurts
staigs75414812staigs
stains64923652stains
stairs65416332stairs
starts65423122starts
stats55933362sta_ts
straits74916322straits
suits55028052s_uits
swails94913122swails
swains94513952swains
swats85726862swa_ts
traits65121982traits
waits88333522_waits

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.356501941.0
2DLD Change Limit825511162.64331233.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911163.04558683.4
 
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.