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

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

96 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
sclaffer1611265(None) 
sclaffed17102671sclaffed
sclaffers17122521sclaffers
chaffer18389472_chaffer
scarfer124511082sc_arfer
sclaff1438312sclaff__
sclaffs1543572sclaff_s
scoffer15317022sc_offer
scuffer15328882sc_uffer
staffer13299092s_taffer
bluffer15396883_bluffer
chafer144714573_cha_fer
chaffed19387703_chaffed
chaffers19378003_chaffers
chaffier1935473_chaffier
chamfer17399863_chamfer
chaufer15347943_chaufer
chauffer19263793_chauffer
chuffer18337143_chuffer
clabber134210113_clabber
clacker153813773_clacker
claimer11279883_claimer
clamber133311743_clamber
clammer134211793_clammer
clamper134012993_clamper
clanger104113493_clanger
clapper134011863_clapper
claquer18287353_claquer
clasher124615513_clasher
clasper113811863_clasper
classer93614613_classer
clatter94014973_clatter
claver113816973_cla_ver
clavier1239173_clavier
clawer114512783_cla_wer
clayier1248323_clayier
cliffier1633913_cliffier
coffer144112863_c_offer
crafter124111333_crafter
fluffer12336503_fluffer
gaffer134310133__gaffer
piaffer15104443_piaffer
quaffer2235133_quaffer
safer84721813s__a_fer
scaler84321603sc_a_ler
scalier94316913sc_alier
scalper113912923sc_alper
scammer133611973sc_ammer
scamper134613163sc_amper
scanner94411813sc_anner
scanter94215183sc_anter
scarcer113911373sc_arcer
scarer84524613sc_a_rer
scarfed134711183sc_arfed
scarfers13408463sc_arfers
scarier94017873sc_arier
scarper114814823sc_arper
scatter93815173sc_atter
scauper11379453sc_auper
sclaffing1843363sclaffing
scoffed16266183sc_offed
scoffers16286133sc_offers
scraper114513423scra_per
scrapper1466973scrapper
scrawler1345893scrawler
scruffier1743303scruffier
scuffed16298243sc_uffed
scuffers16307493sc_uffers
scuffler16286703scuffler
scurfier13267053scurfier
slabber113311393s_labber
slacker133915293s_lacker
slaker104219273s_la_ker
slammer113913033s_lammer
slander84015443s_lander
slapper113512463s_lapper
slasher104515333s_lasher
slater64429183s_la_ter
slather103816073s_lather
slatier74016813s_latier
slaver94419613s_la_ver
slayer93916333s_la_yer
sluffed14308303s_luffed
sniffer13318903s_niffer
snuffer13318853s_nuffer
solacer93011103sola_cer
solander948123solander
splasher1335663splasher
splatter10348883splatter
staffed14298283s_taffed
staffers14247083s_taffers
stiffer13319393s_tiffer
strafer103912463stra_fer
stuffer13349793s_tuffer
suffer124314513s__uffer
zaffer21397153__zaffer

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.423422437.4
2DLD Change Limit146162967.00020880.3
3Display Results96960.0332909.1
 (SQL Overall)178691967.45623966.1
 
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.