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

106 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
spatter9401652(None) 
patter84628261_patter
scatter93815171scatter
shatter103615701shatter
smatter93613331smatter
spatted104014141spatted
spatters103914701spatters
spitter94015181spitter
splatter10348881splatter
spotter94514881spotter
sputter94014051sputter
swatter104113321swatter
batter84928872_batter
bespatter1343142bespatter
blatter94415652blatter
chatter124416642chatter
clatter94014972clatter
fatter94523212_fatter
flatter103815962flatter
hatter94724872_hatter
latter65027892_latter
matter84325342_matter
natter64420742_natter
palter84423262_palter
paster85734372_paster
pater74740722_pa_ter
patted94724682_patted
pattee84323382_pattee
patten84418192_patten
pattern93712052_pattern
patters94825192_patters
patzer173111642_patzer
petter83924772_petter
phatter123810202phatter
platter93917412platter
potter83926982_potter
psalter9247812psalter
putter83921442_putter
ratter64326312_ratter
salter64325082s_alter
scanter94215182scanter
scatted103512772scatted
scatters103612752scatters
scattier10267582scattier
scutter93512172scutter
seater64534162sea_ter
setter64023722s_etter
shatters113313912shatters
shutter103712142shutter
sitter63323382s_itter
skater105015492ska_ter
skitter113810402skitter
slater64429182sla_ter
slather103816072slather
slatier74016812slatier
slatted84015182slatted
slattern837092slattern
slitter73615872slitter
slotter73314452slotter
smarter94113132smarter
smatters104011712smatters
spacer104917792spa_cer
spacier114011632spacier
spader94317132spa_der
spaller92713472spaller
spammer133410432spammer
spanker133612352spanker
spanner94312562spanner
sparer84524962spa_rer
sparger103613082sparger
sparker133914362sparker
sparser94311482sparser
spate74731582spa_te_
spates85028172spa_tes
spathe115115692spathe_
spathed134013182spathed
spathes125116532spathes
spattered12187642spattered
spawner12347362spawner
specter113111732specter
spelter94113702spelter
spitted103912702spitted
spitters104113382spitters
splatted11356742splatted
splatters11327542splatters
splitter10348442splitter
splutter10357442splutter
sporter93616552sporter
spotted103713142spotted
spotters104313382spotters
spottier10207312spottier
spouter94213222spouter
spurter94013002spurter
sputters104012872sputters
sputtery13366472sputtery
squatter1735912squatter
starter73817882starter
stater64427562sta_ter
stutter72911462stutter
swather134213602swather
swatted114110692swatted
swatters113911792swatters
swotter10399472swotter
tatter64024572_tatter
watter93221982_watter
yatter94116212_yatter

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 Filter1786911076710.390458182.1
2DLD Change Limit1076711063.31032529.0
3Display Results1061060.0333212.1
 (SQL Overall)1786911063.73347867.9
 
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.