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 “paliest” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
paliest9302160(None) 
paciest112917801paciest
palest83926221pal_est
palliest102814631palliest
palmiest123212021palmiest
alist56136782_ali_st
babiest114414752babiest
baldest102313532baldest
balkiest144112452balkiest
balmiest124110992balmiest
cagiest102916432cagiest
cakiest133215662cakiest
calmest11312342calmest
coaliest10316222coaliest
earliest82415242earliest
easiest72318772easiest
eeliest73516472eeliest
falsest10310012falsest
fliest94718432_fliest
gamiest102816222gamiest
halest94823272hal_est
haziest193313002haziest
holiest104319622holiest
laciest93819032laciest
lakiest113517262lakiest
laziest163814472laziest
malmiest123211022malmiest
maltiest102916192maltiest
manliest102314942manliest
marliest102415182marliest
matiest92522452matiest
maziest183613872maziest
mealiest102215972mealiest
oakiest112913922oakiest
oiliest72817682oiliest
pales75753802pal_es_
palet74650802pal_e_t
palets85122312pal_ets
palier85023562palie_r
palish114718272pali_sh
pallet84232652palle_t
pallets93919302pallets
palmist112814342palmist
palsies94420272palsies_
paltriest1138602paltriest
papist102618742papi_st
pappiest112611112pappiest
paries84742512paries_
pastiest103319542pastiest
patient9617072patient
pawkiest17277882pawkiest
peakiest143512992peakiest
pearliest1139352pearliest
peatiest103118802peatiest
piniest93121132piniest
pipiest113114492pipiest
plainest10313612plainest
platiest103216082platiest
plies74526512p_lies_
pokiest133314912pokiest
polies84034582polies_
politest10312942politest
poxiest163412252poxiest
priest84125422p_riest
pulpiest1258432pulpiest
puniest92918092puniest
raciest92820012raciest
ruliest72816432ruliest
sagiest82617982sagiest
salient7419762salient
saltest71916512saltest
saltiest83117712saltiest
scaliest101714392scaliest
shaliest111415052shaliest
sliest66621952_sliest
spaciest122310892spaciest
talkiest123611222talkiest
tallest7317092tallest
ugliest8410152ugliest
vealiest112513202vealiest
walies95324522walies_
waniest103819112waniest
wariest105122502wariest
waviest134513072waviest
waxiest173510882waxiest
wiliest103416592wiliest
zaniest163214772zaniest

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.373479064.3
2DLD Change Limit107671873.37631893.1
3Display Results87870.0302900.0
 (SQL Overall)178691873.77947285.3
 
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.