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

112 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
chaster12471850(None) 
caster85232571c_aster
chanter123919731chanter
chapter144213851chapter
charter123918301charter
chaser114918381chas_er
chaste114617391chaste_
chasten124312401chasten
chatter124416641chatter
coaster94219041coaster
aster55434892__aster
baster85333592_baster
blaster94017302blaster
boaster94616432boaster
cadaster1136902cadaster
canter85230112c_anter
carter84932272c_arter
caste75932362c_aste_
casters94729902c_asters
castes85631862c_astes
castor84418532c_astor
cater74840722c_a_ter
chafer144714572cha_fer
chaffer18389472chaffer
chamber164011062chamber
chamfer17399862chamfer
champer163813412champer
chancer144215632chancer
changer134215542changer
chanted134015952chanted
chanters134016742chanters
chantey154112542chantey
chantor123710312chantor
chapiter1536602chapiter
chapters154012132chapters
charger133914062charger
charier124317902charier
charmer144913662charmer
charted135116852charted
charters134115582charters
chase105127122chas_e_
chased125019292chas_ed
chasers123714922chas_ers
chases115128232chas_es
chasmed154710172chasmed
chasse115114602chasse_
chassed134712132chassed
chasses124017502chasses
chasseur1343442chasseur
chastely1635812chastely
chastener1445702chastener
chastens13429182chastens
chastest1349702chastest
chastiser1444372chastiser
chatted133411892chatted
chattel12388892chattel
chatters134213952chatters
chattery16357272chattery
chattier1337512chattier
chaufer15347942chaufer
chaunter1366392chaunter
chawer144314412cha_wer
cheater124816962cheater
chested133811672chested
chestier1387422chestier
chitter124112962chitter
chunter123911482chunter
clasher124615512clasher
clasper113811862clasper
classer93614612classer
clatter94014972clatter
cluster94013332cluster
clyster12317452clyster
coasted104015962coasted
coasters104317342coasters
coater84329572coa_ter
coster84331292c_oster
crafter124111332crafter
crasher124616162crasher
crasser94114342crasser
crater85026642cra_ter
cytaster1383862cytaster
diaster82813312diaster
easter65027982_easter
faster94625772_faster
feaster10812982feaster
gaster75027352_gaster
hafter124815882_hafter
halter94420882_halter
hamster12810422_hamster
haste85927862_haste_
hasted105125282_hasted
hasten95718562_hasten
hastes95727072_hastes
hastier103916622_hastier
hater85034752_ha_ter
hatter94724872_hatter
laster64830632_laster
master84831342_master
paster85734372_paster
phatter123810202phatter
piaster93012882piaster
plaster93318692plaster
raster64731442_raster
roaster74116662roaster
shatter103615702shatter
shyster13116562shyster
taster64930572_taster
toaster74414462toaster
unchaster1445392unchaster
vaster94521022_vaster
waster95228942_waster

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.393454684.5
2DLD Change Limit1076711123.48330913.3
3Display Results1121120.0303733.3
 (SQL Overall)1786911123.90645747.8
 
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.