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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

181 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
desalters103767(None) 
desalter938361desalter_
dealers84118612de_al_ers
debaters113511912deba_ters
decaliters1345212decaliters
decanters12229222decanters
defaulters1442382defaulters
deflaters13298692deflaters
dekaliters1543412dekaliters
desalted1038312desalte_d
desalts839572desalt__s
descanters1345012descanters
deserters10129982deserters
desilvers13306082desilvers
desolaters1146042desolaters
dewaters122910712dewa_ters
disasters1039142disasters
drysalters1441852drysalters
exalters1536652_exalters
misalters1136902misalters
psalters10227712_psalters
realters83614042re_alters
salters73622252__salters
alters64924223___alters
assaulters1042463assaulters
basaltes10367683basalte_s
beaters94925033be_a_ters
belters93819413be__lters
besetters11136633besetters
bespatters1442783bespatters
betatters1134963betatters
darters84017603d__arters
daters74827363d__a_ters
dealates92716683de_alate_s
dealer74122143de_al_er_
debarkers16164553debarkers
debasers11377903deba_sers
debater104114693deba_ter_
debates103718523deba_te_s
decaliter1247983decaliter_
decameters15156593decameters
decanter112510793decanter_
decayers14307963deca_yers
decenters122410373decenters
deciliters1345173deciliters
declarers1236423declarers
deemsters1285023deemsters
defacers14237993defa_cers
defamers14258523defa_mers
defaulter1343133defaulter_
defeaters13289093defeaters
defilers12439473defil_ers
deflater123211603deflater_
deflates123013943deflate_s
deflators13348153deflators
degassers11354833degassers
dekaliter1445063dekaliter_
dekalitres1542963dekalitres
dekameters17164863dekameters
delates83526283dela_te_s
delators92314823dela_tors
delayers12268663dela_yers
delusters1035973delusters
delvers113411993de__lvers
demanders13247573demanders
demisters1249203demisters
dempsters1435273dempsters
departees1265723departees
depicters1435823depicters
depleters12327533depleters
deporters1277793deporters
derangers1136703derangers
derates84028883dera_te_s
desalt7518313desalt___
desalting1138843desalting
descanter1246443descanter_
descriers1245693descriers
deserter91211603deserter_
deservers13107293deservers
designers1136003designers
desilver12286503desilver_
desirers939263des_irers
desolater1038383desolater_
desolates10311793desolate_s
desolators1146283desolators
despairers1343103despairers
despisers1245153despisers
despites11410313despite_s
destriers1038143destriers
desulfurs1342243desulfurs
desultory1343403desultory
detachers1536483detachers
detailers10257253detailers
detainers10269103detainers
detecters12217753detecters
deters74724683de___ters
detesters10298303detesters
devalues1235853devalue_s
dewater112912423dewa_ter_
dialers83614293d_ial_ers
diallers957773d_iallers
diasters92913173d_iasters
diesters92513593dies__ters
dilaters92513053dila_ters
disablers1255803disablers
disarmers1246943disarmers
disaster949943disaster_
disinters1039703disinters
disputers1236603disputers
drafters12338523d_rafters
drysalter1341933drysalter_
drysaltery1751263drysaltery
dusters84918353dus__ters
easters75125683_e_asters
eaters65535943_e_a_ters
elaters74420183_ela_ters
espaliers1144123_espaliers
esters64627733_es__ters
exacters1736773_exacters
exalter1437563_exalter_
falters103916473__falters
feasters11511563fe_asters
festers104121393fes__ters
gasaliers1044513gasaliers
halters104619803__halters
healers104319463he_al_ers
heaters104225213he_a_ters
insulters945873insulters
jesters144118193jes__ters
kelters113813753ke__lters
levanters1254993levanters
melters93918313me__lters
misalter1038343misalter_
negaters9349773nega_ters
nesters74422783nes__ters
nestlers8359223nestl_ers
palters94021683__palters
pedalers11239393pedal_ers
pedalfers1542903pedalfers
pedaliers1245183pedaliers
pedallers1244753pedallers
pelters93720313pe__lters
pesters93827093pes__ters
prealters1147773prealters
psalter9247813_psalter_
psaltery13224733_psaltery
realter73716313re_alter_
realtors82811683re_altors
rebaters103413913reba_ters
recallers1137093recallers
recanters112310483recanters
refilters1236103refilters
regalers94311123regal_ers
relaters83218143rela_ters
remasters11310583remasters
resales74724903resal_e_s
resalutes947433resalute_s
resellers9299903resellers
resetters9129463resetters
resilvers12306503resilvers
resisters9310453resisters
reslates83619493reslate_s
resolders10258013resolders
resolvers12297833resolvers
resorters939683resorters
resters74130403res__ters
revolters12297483revolters
salter64325083__salter_
saltern74010653__saltern
salterns8388893__salterns
saltiers83411953__saltiers
saluters8319853__saluters
salvers103916003__salvers
sealers74323553se_al_ers
seaters74028933se_a_ters
slaters73123723__slaters
testers74124543tes__ters
vealers103214293ve_al_ers
welters103516063we__lters
westers105221963wes__ters
zesters163517293zes__ters

Search took 9 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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411818.12618292.0
3Display Results1811810.0802262.5
 (SQL Overall)1786911818.37621333.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.