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 “blatter” 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
blatter9441565(None) 
batter84928871b_atter
blaster94017301blaster
blather125314201blather
blatted104812711blatted
blatters104414091blatters
blotter94612851blotter
clatter94014971clatter
flatter103815961flatter
latter65027891_latter
platter93917411platter
baiter84422552b_aiter
banter84825332b_anter
barter85525372b_arter
baster85333592b_aster
bather115322512b_ather
batted95623652b_atted
batten85217122b_atten
batters94626012b_atters
battery124911812b_attery
battier93515712b_attier
battler94113382b_attler
beater84729392bea_ter
betatter1035452betatter
better84723702b_etter
bitter84622672b_itter
blabber10418922blabber
blacker154513512blacker
bladder11429152bladder
blader93618582bla_der
blamer104417142bla_mer
blander103715162blander
blanker134612022blanker
blasted104213472blasted
blasters104116142blasters
blastier10249492blastier
blate75933782bla_te_
blathers134713792blathers
blattered12198562blattered
blazer174414022bla_zer
bleater94515302bleater
blether12459912blether
blister94415312blister
blither124812172blither
blitzer18447662blitzer
bloater94013422bloater
blotted103911832blotted
blotters104110982blotters
blottier10336412blottier
blunter94512032blunter
blurter9419832blurter
bluster94215312bluster
boaster94616432boaster
boater84622092boa_ter
brattier1047662brattier
butter84724232b_utter
chatter124416642chatter
clatters103313912clatters
clattery13378192clattery
clutter94211662clutter
elater64724202ela_ter
fatter94523212_fatter
flatted114012942flatted
flatten10429652flatten
flatters113814202flatters
flattery14338292flattery
flitter103413902flitter
flutter104012092flutter
glitter84211802glitter
hatter94724872_hatter
laster64830632_laster
later54843922_la_ter
lather95124352_lather
latte55426302_latte_
latten65018202_latten
lattes65324202_lattes
letter63722582_letter
litter64324852_litter
lotter64025602_lotter
matter84325342_matter
natter64420742_natter
patter84628262_patter
phatter123810202phatter
plaiter93615392plaiter
planter94017802planter
plaster93318692plaster
plater84427692pla_ter
platier93716292platier
platted103614262platted
platters103415282platters
plotter94113662plotter
ratter64326312_ratter
scatter93815172scatter
shatter103615702shatter
slater64429182sla_ter
slather103816072slather
slatier74016812slatier
slatted84015182slatted
slattern837092slattern
slitter73615872slitter
slotter73314452slotter
smatter93613332smatter
spatter94016522spatter
splatter10348882splatter
swatter104113322swatter
tatter64024572_tatter
watter93221982_watter
yatter94116212_yatter

Search took 5 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.406440125.6
2DLD Change Limit1076711084.50023926.9
3Display Results1081080.0502160.0
 (SQL Overall)1786911084.95636055.5
 
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.