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

107 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
peltasts103570(None) 
peltast9310511peltast_
heliasts1136102heliasts
pectases122411192pectases
peltate92013772pelta_te
petasos948602pe_tasos
petasus946362pe_tasus
ballasts1037933ballasts
beasts84519723be__asts
blasts85116773_bl_asts
cellists1038563cellists
clasts84817293_cl_asts
cultists10107633cultists
delists84414173del_ists
deltas74414823delta__s
demasts1089223de_masts
dentists939263dentists
detests83711743de_tests
easts57530323_e__asts
ectases92911673_ectases
ectasis9249613_ectasis
elitists848543_elitists
eluants737583_eluants
entases72816273_entases
entasis73012573_entasis
epitases1038933epitases
epitasis1047433epitasis
fantasts1147113fantasts
feasts95116093fe__asts
gelants82611443gel_ants
gellants9308283gellants
gestalts955493gestalts
heliast10312073heliast_
lasts57731263__l_asts
leasts64616413__leasts
leftists11235513leftists
maltases1039693maltases
meltages1148243meltages
oblasts947293obl_asts
outlasts8108713outlasts
palmists12268813palmists
pasts75936503p___asts
peasants1038263peasants
peases85229473pe__ases
peats76140193pe__a_ts
pectase112410363pectas_e
pectate112214693pecta_te
pectates122213953pectates
pedants10310113pe_dants
pederasts1255203pederasts
pelages10714613pel_ages
pelisses1048483pelisses
pellets94014783pel_lets
pelmets11309693pel_mets
pelotas9410723pelota__s
pelters93720313pelt_ers
peltless10267373peltless
peltries10313023peltries
pelts76128813pel___ts
pelvises1337273pelvises
pendants1139093pendants
pennants1037063pennants
pentads1039523penta_ds
pentanes10316083pentanes
pentoses10312893pentoses
peptalks1653843peptalks
periapts1237273periapts
persalts1038193persalts
persists1049183persists
pertains102113423pertains
pertest9317043pertest_
pests75933273pe___sts
petals84719813pe_ta_ls
petards104311153pe_tards
petsais938433pe_tsais
phantasts1443953phantasts
pietists1038323pietists
plaits83816473p_l_aits
plants84921803p_l_ants
plasms103711333p_l_asms
plats75531373p_l_a_ts
pleases94515483p_leases
pleats85218593p_lea_ts
plenists1038253plenists
pollists10910823pollists
poloists10910523poloists
precasts1239453precasts
pretaste10139523pretaste
pretastes11119423pretastes
pretests10310013pretests
protases102115033protases
protasis102411973protasis
protests10310493protests
protists10313363protists
recasts93413533re_casts
releases8313343releases
relists73817053rel_ists
repasts93611933re_pasts
restarts8310873restarts
retaste72313133re_taste
retastes82212903re_tastes
retests73813853re_tests
sextants15287383sextants
telecasts1145543telecasts
teleosts846423teleosts
webcasts1543313webcasts
yeasts96413053ye__asts

Search took 8 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621077.70318974.7
3Display Results1071070.0333242.4
 (SQL Overall)1786911077.90622601.9
 
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.