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

172 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
chaffier193547(None) 
chaffer18389471chaff_er
chuffier1934541chuffier
chafer144714572cha_f_er
chaffed19387702chaff_ed
chafferer20133922chafferer
chaffers19378002chaff_ers
chaffiest2045422chaffiest
chaffing2036322chaffing
chalkier1736752chalkier
chamfer17399862chamf_er
chancier1538822chancier
charier124317902cha_rier
charrier1378692charrier
chattier1337512chattier
chaufer15347942chauf_er
chauffer19263792chauffer
chuffer18337142chuff_er
cliffier1633912cliffier
craftier1376192craftier
daffier1457832_daffier
draffier1574322draffier
huffier1637492_huffier
affixer2033913__affixer
baffies153612943_baffies
baffler15418113_baffler
buffier1568403_buffier
caffein1535333c_affein
cagier93715933c_a_gier
cahier113615773c_a_hier
cakier123115243c_a_kier
campier133313273c_ampier
cannier94014163c_annier
carrier93619583c_arrier
cashier123713323c_ashier
cattier93317073c_attier
chafe135117353cha_f_e_
chafed154813913cha_f_ed
chafers154512743cha_f_ers
chafes145017913cha_f_es
chaff165016283chaff___
chaffered21154483chaffered
chafferers21153173chafferers
chaffinch2542043chaffinch
chaffs17459613chaff__s
chaffy20456473chaff__y
chafing163911493cha_fing
chair105519633cha__i_r
challie124012853challie_
challies133915643challies
chamber164011063cha_mber
chamferer19154693chamferer
chamfers18409223chamf_ers
chammied18215973chammied
chammies172910163chammies
champer163813413cha_mper
chancer144215633cha_ncer
chandler14358373chandler
changer134215543cha_nger
chanter123919733cha_nter
chanties132615803chanties
chapiter1536603chapiter
chappie16298663chappie_
chappies172610103chappies
chapter144213853cha_pter
charger133914063cha_rger
charlie123011923charlie_
charlies133414233charlies
charmer144913663cha_rmer
charter123918303cha_rter
chaser114918383cha__ser
chaster124718503cha_ster
chastiser1444373chastiser
chatter124416643cha_tter
chaufers16347303chauf_ers
chauffers20253443chauffers
chauffeur20221983chauffeur
chaunter1366393chaunter
chawer144314413cha__wer
cheekier1735103cheekier
cheerier1348013cheerier
cheesier1335963cheesier
cheffed19335863cheff_ed
cheffing2034463cheffing
chertier1387873chertier
chestier1387423chestier
chewier1537593ch_ewier
chichier1836023chichier
chiefer1536863chief_er
chiffonier2151503chiffonier
chillier13328423chillier
chinkier17377363chinkier
chippier17297673chippier
chirpier15276303chirpier
chokier1638043ch_okier
choosier1337183choosier
choppier17286653choppier
chromier1538033chromier
chubbier1733893chubbier
chuffed19316643chuff_ed
chuffiest2044403chuffiest
chuffing2055043chuffing
chummier1734513chummier
chunkier17395883chunkier
clammier1435843clammier
clankier14327083clankier
clarifier1446123clarifier
classier10359083classier
clavier1239173cla_vier
clayier1248323cla_yier
coalier93416183coa_lier
codifier1447163codifier
coffer144112863c_off_er
comfier1439163c_omfier
crabbier14326803crabbier
crafter124111333cra_fter
craggier12116063craggier
crampier14288903crampier
crankier14339163crankier
crappier14288143crappier
crawlier13216873crawlier
crazier183610743cra_zier
draftier1285263draftier
fluffier13264333fluffier
gaffer134310133_gaff_er
gruffier1544703gruffier
haffet15311703_haff_et
haffit1538533_haffi_t
haffits1636193_haffits
hafter124815883_ha_fter
hairier103111053_hairier
hammier143510653_hammier
handier113817443_handier
happier143312043_happier
hardier114721543_hardier
harrier104417763_harrier
hastier103916623_hastier
haulier1059943_haulier
hazier184712403_ha_zier
heftier1337203_heftier
iffier1236763__iffier
kaffir16345303_kaffi_r
leafier10329833lea_fier
miffier1537023_miffier
piaffer15104443piaff_er
puffier1547973_puffier
quaffer2235133quaff_er
raffler13339223_raffler
sclaffer16112653sclaff_er
scruffier1743303scruffier
shabbier1535183shabbier
shadier113111153sha_dier
shaggier13116053shaggier
shakier143411153sha_kier
shalier103116423sha_lier
shiftier1436343shiftier
shuffler17306803shuffler
sniffier14356643sniffier
snuffier14276943snuffier
spiffier16255883spiffier
staffer13299093staff_er
stuffier14336623stuffier
taffies133012693_taffies
waffie15338563_waffie_
waffies163611443_waffies
waffler16377783_waffler
wafflier1733953_wafflier
whackier2044673whackier
whiffer19105323whiff_er
whiffler2033483whiffler
zaffer21397153_zaff_er
zaffir21395513_zaffi_r

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621728.15617920.8
3Display Results1721720.0632730.2
 (SQL Overall)1786911728.65520646.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.