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

127 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
hasteners1226781(None) 
chasteners1554791chasteners
fasteners12237051fasteners
hastener11259131hastener_
batteners11238162batteners
chastener1445702chastener_
chasteness1546522chasteness
easterners1044822easterners
fastener11227832fastener_
fatteners12236872fatteners
haptenes133810822haptene_s
hardeners1338082hardeners
harkeners1636072harkeners
hastened12239102hastene_d
hastens106214812hasten__s
hastiness122410882hastiness
hearteners1346212hearteners
hostelers1246642hostelers
listeners9147322listeners
ratteners9237262ratteners
alieners889823_alieners
alterers82512493_alterers
ascenders1235683_ascenders
assenters966993_assenters
asters65631603_ast__ers
atoners75013953_a_toners
attenders1045273_attenders
banterers112410003banterers
bartenders1344223bartenders
barterers11269633barterers
baseness10910943bas_eness
basters94930303bast__ers
battener10369393battener_
batterers113110713batterers
careeners1138543careeners
cassenes103611293cassene_s
castanets1146333castanets
casters94729903cast__ers
caterers102814403ca_terers
charterers15146053charterers
chastened1545883chastene_d
chastens13429183chasten__s
chastisers1543173chastisers
chatterers15205463chatterers
dampeners1444663dampeners
darkeners1435153darkeners
distenders12166733distenders
easterner945053easterner_
easters75125683east__ers
falterers12238033falterers
fastened12257853fastene_d
fastens105511753fasten__s
fastness11238763fast_ness
fattener11268113fattener_
flatteners13164153flatteners
fosterers12238023fosterers
gardeners1136603gardeners
gasters85624293gast__ers
gastness9278473gast_ness
hafters134614333haft__ers
haleness11312623ha_leness
halteres113414603haltere_s
halters104619803halt__ers
hammerers16216563hammerers
hamperers16287533hamperers
hamsters13710423hamst__ers
hankerers16226713hankerers
haptene123810933haptene__
haptens124511343hapten__s
hardener1238883hardener_
harkener1537573harkener_
hasten95718563hasten___
hastening13259483hastening
hastes95727073hast__e_s
hastier103916623hast_ier_
hatchers163113173ha_tchers
haters94930403ha_t__ers
hatters104221523ha_t_ters
hauteurs1133733haute_urs
hearkeners1743983hearkeners
heartener1256763heartener_
histones11312803histone_s
hosteler1137283hosteler_
hostellers1344683hostellers
hostlers113310483host_lers
hustlers11349203hust_lers
larceners1135993larceners
lasters75627693last__ers
lateeners945563lateeners
lateness82614073la_teness
listener8158313listener_
masseters1136283masseters
masters94628923mast__ers
moisteners1244783moisteners
nastiness92310573nastiness
oysterers1245573oysterers
palterers11249533palterers
parceners1337453parceners
partners102711133part_ners
passengers1343213passengers
pasters94531733past__ers
pastiness112312353pastiness
pastness102510503past_ness
pasturers1136393pasturers
patterers112410123patterers
pesterers112510463pesterers
plasterers1286123plasterers
rasters74629023rast__ers
rattener8238533rattener_
raveners11309133ra_veners
sharpeners1543893sharpeners
shatterers13185723shatterers
shorteners1345083shorteners
softeners1245133softeners
steers63820983__ste_ers
stoners74817953__stoners
tasteless935673tasteless
tasters74225643tast__ers
tastiness92311143tastiness
vastness11257293vast_ness
wakeners1535843wa_keners
wantoners12116673wantoners
warreners1236193warreners
wasters104026593wast__ers
waterers112312783wa_terers
westerners1344473westerners
whiteners1535243whiteners

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411276.62622433.0
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.10925135.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.