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

163 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
palets8512231(None) 
pales75753801pale_s
palest83926221palest
palet74650801palet_
pallets93919301pallets
valets93715621valets
abets75621672_abets
aglets73915682aglets
alecs76620732_alecs
alefs87319662_alefs
alerts64418222_alerts
ales47067102_ale_s
alts46639902_al_ts
applets115710062applets
balers85626932balers
bales76250082bale_s
ballets93719512ballets
blets75324942_blets
cablets114216342cablets
cadets96316512cadets
callets93821702callets
camlets114314622camlets
caplets114914522caplets
carets85330772carets
chalets122813472chalets
culets85518512culets
dales66439742dale_s
daleth1038632daleth
daleths1135322daleths
eaglets84111662eaglets
epaulets1043732epaulets
facets116316652facets
filets94718952filets
galeas74618512galeas
gales65442482gale_s
gallets83517402gallets
haets86525122ha_ets
halers94926912halers
hales85449842hale_s
halest94823272halest
halts85230102hal_ts
hamlets123211402hamlets
haslets102510862haslets
inlets63915572inlets
islets64513082islets
kales95730982kale_s
lets47147942__lets
males75049792male_s
mallets93318492mallets
malts76331752mal_ts
naleds7469132naleds
owlets93110392owlets
pacers105124542pacers
paces96741112pace_s
packets155114772packets
pacts95125802pa_cts
padles95221122padle_s
pagers94423252pagers
pages85235072page_s
paints85921832paints
palais8420422palais
palate84226782palate
palates93624932palates
pale66055012pale__
palea75028662pale_a
paleae84820292paleae
paleal84716672paleal
paleate94120002paleate
paled85538722pale_d
palely11311922palely
paler75436932pale_r
paletot9413712paletot
paletots1047802paletots
palette93613982palette
palettes103112832palettes
paliest93021602paliest
pallet84232652pallet_
palls74332562pal_ls
palmers113513622palmers
palms94921752pal_ms
palps94719562pal_ps
palpus104210282palpus
pals66951352pal__s
palter84423262palter
palters94021682palters
panels84716522panels
panes76148692pane_s
pants76536922pa_nts
papers105125322papers
parents93418122parents
pareos87023772pareos
parers85530742parers
pares77164482pare_s
pareus85420742pareus
pargets105215192pargets
parles86334402parle_s
parleys125212372parleys
partlets102811512partlets
parts77743372pa_rts
paseos88015812paseos
pases75346502pase_s
pastes85233912pastes
pasts75936502pa_sts
patens84820862patens
patents94815202patents
paters84935832paters
pates76047892pate_s
pats66460852pa__ts
pavers115021822pavers
paves104833922pave_s
pawers114818782pawers
paxes144928422paxe_s
payees114812902payees
payers114621822payers
peles75738082pele_s
pellets94014782pellets
pelmets11309692pelmets
pelts76128812pel_ts
pets66248332p__ets
piglets103311792piglets
piles74742612pile_s
pileus84514942pileus
pilots84018872pilots
piolets93513192piolets
pipets105714772pipets
placets113911222placets
plaits83816472plaits
planets93914082planets
plants84921802plants
plates85432242plates
plats75531372p_lats
playlets1334902playlets
pleas75627032p_leas
pleats85218592p_leats
plebs95814582p_lebs
plews105415352p_lews
plots75025672p_lots
poets76024442p_oets
poleis86018352poleis
polers84225642polers
poles75351002pole_s
pulers83820282pulers
pules74538812pule_s
pullets94015162pullets
rales54947492rale_s
ramets83517392ramets
relets64025672relets
saleps85014902saleps
sales56055592sale_s
sallets73719652sallets
salts55431882sal_ts
samlets93813552samlets
spales84728102spale_s
tablets94714372tablets
talents7312012talents
talers64628142talers
tales55451372tale_s
vales85434262vale_s
valet84337872valet_
varlets10411572varlets
walers94824462walers
wales86142832wale_s
wallets103914832wallets

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.1101624463.6
2DLD Change Limit825511632.95327955.0
3Display Results1631630.0463543.5
 (SQL Overall)1786911633.10957475.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.