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

114 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
platter9391741(None) 
blatter94415651blatter
clatter94014971clatter
flatter103815961flatter
latter65027891_latter
patter84628261p_atter
phatter123810201phatter
plaiter93615391plaiter
planter94017801planter
plaster93318691plaster
plater84427691pla_ter
platier93716291platier
platted103614261platted
platters103415281platters
plotter94113661plotter
splatter10348881splatter
batter84928872_batter
blaster94017302blaster
blather125314212blather
blatted104812712blatted
blatters104414092blatters
blotter94612852blotter
chatter124416642chatter
clatters103313912clatters
clattery13378192clattery
clutter94211662clutter
elater64724202ela_ter
fatter94523212_fatter
flatted114012942flatted
flatten10429652flatten
flatters113814202flatters
flattery14338292flattery
flitter103413902flitter
flutter104012092flutter
glitter84211802glitter
hatter94724872_hatter
laster64830632_laster
later54843922_la_ter
lather95124362_lather
latte55426302_latte_
latten65018202_latten
lattes65324202_lattes
letter63722582_letter
litter64324852_litter
lotter64025602_lotter
matter84325342_matter
natter64420742_natter
palter84423262p_alter
paster85734372p_aster
pater74740722p_a_ter
patted94724682p_atted
pattee84323382p_attee
patten84418192p_atten
pattern93712052p_attern
patters94825192p_atters
patzer173111642p_atzer
pearter9412742pearter
peatier94017232peatier
petter83924772p_etter
piaster93012882piaster
pilaster1038162pilaster
placater1238012placater
placer105117742pla_cer
plaguer10328272plaguer
plainer93811982plainer
plaister1068012plaister
plaited103713892plaited
plaiters103512632plaiters
planer84122652pla_ner
plankter1435362plankter
planner93511622planner
plantar9369992plantar
planted103516122planted
planters102915322planters
plasher124215032plasher
plasters103518132plasters
plastery13279702plastery
plate74635112pla_te_
plated95225772pla_ted
platen84518202pla_ten
platers93924092pla_ters
plates85432242pla_tes
platies93722542platies
player115215212pla_yer
pleater93916332pleater
pleather1356652pleather
plotted104612372plotted
plotters104011552plotters
plottier10327262plottier
potter83926982p_otter
prater84825352pra_ter
prattler10166342prattler
psalter9247812psalter
putter83921442p_utter
ratter64326312_ratter
scatter93815172scatter
shatter103615702shatter
slater64429182sla_ter
slather103816082slather
slatier74016812slatier
slatted84015182slatted
slattern837092slattern
slitter73615872slitter
slotter73314452slotter
smatter93613332smatter
spatter94016522spatter
splatted11356742splatted
splatters11327542splatters
splitter10348442splitter
splutter10357442splutter
swatter104113322swatter
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.360496363.9
2DLD Change Limit1076711143.29632667.2
3Display Results1141140.0462478.3
 (SQL Overall)1786911143.70248268.8
 
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.