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

234 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
plates8543224(None) 
alates64833971alates
elates65032361elates
palates93624941palates
pates76047891p_ates
places104323701places
plages94520151plages
planes85028081planes
plate74635111plate_
plated95225771plated
platen84518201platen
platens94213981platens
plater84427691plater
platers93924091platers
platies93722541platies
plats75531371plat_s
platys11459851platys
prates84633161prates
slates64934061slates
abates85825042abates
ablates92416912ablates
agates76121342agates
alate55340332alate_
alated75625152alated
aplites9314932aplites
ates45047922__ates
bates75846342_bates
blades95221252blades
blames105121862blames
blares85021632blares
blate75933782blate_
blats75132502blat_s
blazes174817352blazes
blites84721212blites
cates75951892_cates
clades94920462clades
claves115020062claves
crates85736062crates
dates65639152_dates
delates83526282delates
dilates83220662dilates
elate55335882elate_
elated74725822elated
elater64724202elater
elaters74420192elaters
elites66027122elites
eluates72014682eluates
elutes64020312elutes
enates64026432enates
epilates10313502epilates
fates85139232_fates
flakes134118872flakes
flames114723692flames
flanes94522422flanes
flares94521702flares
flats86429742flat_s
flatus94310782flatus
flaxes165015352flaxes
flites95122442flites
flutes95421782flutes
flytes123911562flytes
folates103218452folates
gates65939512_gates
gelates83219592gelates
glaces94218032glaces
glades84820342glades
glares75518872glares
glazes165315642glazes
glutes74517672glutes
grates75429892grates
hates86742572_hates
laces76141762_laces
lades65141272_lades
lakes95737652_lakes
lames75445542_lames
lanes54946792_lanes
lares54852632_lares
lases54944762_lases
late47560482_late_
lated65240672_lated
laten54328342_laten
latens64620212_latens
later54843922_later
latest63822702_latest
latex124717112_latex
lathes95127502_lathes
laths86022402_laths
latkes104715872_latkes
lats45962702_lat_s
lattes65324202_lattes
laves86039152_laves
laxes125430092_laxes
lazes145129572_lazes
lutes55836662_lutes
malates93522612malates
mates75251362_mates
nates55238332_nates
oblates91913242oblates
oleates7417832oleates
opiates9312142opiates
orates64328612orates
paces96741112p_aces
pages85235072p_ages
palaces114216462palaces
palate84226792palate_
pales75753802p_ales
palets85122312palets
palpates122613062palpates
palter84423262palter
palters94021682palters
panes76148692p_anes
pares77164482p_ares
pases75346502p_ases
pastes85233912pastes
pate65350462p_ate_
pated85237842p_ated
paten74827342p_aten
patens84820862p_atens
pater74740732p_ater
paters84935842p_aters
paths105521382p_aths
pats66460852p_at_s
paves104833922p_aves
paxes144928422p_axes
peaces106324082peaces
peages94321852peages
peases85229472peases
peats76140192peat_s
pelages10714612pelages
pelites93821992pelites
penates93321602penates
phages125213512phages
phases114618402phases
pirates93020332pirates
pistes85325632pistes
placates12311762placates
place94824612place_
placed114318002placed
placer105117742placer
placers114515262placers
placet103923672placet
placets113911222placets
placks144414152placks
plage84520402plage_
plagues103311062plagues
plaices11411152plaices
plaids94312442plaids
plains85019592plains
plaited103713892plaited
plaiter93615392plaiter
plaiters103512632plaiters
plaits83816472plaits
plane74929142plane_
planed94420912planed
planer84122662planer
planers94517952planers
planet84228352planet
planets93914082planets
planks124116752planks
plans75731272pla_ns
planted103516122planted
planter94017812planter
planters102915332planters
plants84921802plants
plaques18317892plaques
plashes124417392plashes
plasms103711332plasms
plaster93318692plaster
plasters103518132plasters
plat66048872plat__
platan83913692platan
platanes102711882platanes
platans93413122platans
plateau937402plateau
plateaus1035532plateaus
platier93716292platier
platiest103216092platiest
platted103614262platted
platter93917412platter
platters103415282platters
platy105021662plat_y
playas114612282playas
played124815032played
player115215212player
players124313762players
plays106320772pla_ys
plazas17409912plazas
pleases94515482pleases
pleated103816632pleated
pleater93916332pleater
pleaters103613792pleaters
pleats85218592pleat_s
plebes104313622plebes
plexes155313542plexes
plies74526512pl_ies
plots75025672plot_s
plotzes18317702plotzes
plumes104318132plumes
pluses83618072pluses
plutei8408902plutei
pluteus9326242pluteus
pontes83627852pontes
prases84429022prases
prate75135982prate_
prated94924922prated
prater84825352prater
praters94921652praters
prats76333392prat_s
praxes156215182praxes
prelates10418582prelates
pulsates1048812pulsates
pupates113311432pupates
rates55352012_rates
relates73731442relates
replates102919282replates
sates54949322_sates
skates104219402skates
slakes104021882slakes
slate55438282slate_
slated75028312slated
slater64429182slater
slaters73123732slaters
slatey95417062slatey
slats55436902slat_s
slaves95023022slaves
solates73523852solates
spates85028172spates
splakes1349672splakes
splats84817302splat_s
states64337082states
tates55444982_tates
updates10329792updates
uprates93814862uprates
urates65027762urates

Search took 3 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.360496363.9
2DLD Change Limit825512342.51632810.4
3Display Results2342340.0763078.9
 (SQL Overall)1786912342.95260532.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.