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

156 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
draffier157432(None) 
daffier1457831d_affier
draftier1285261draftier
chaffier1935472chaffier
craftier1376192craftier
draffiest1644362draffiest
draffish1844552draffish
drafter11449432dra_fter
draggier11135772draggier
drawlier12225252drawlier
driftier1275122driftier
gruffier1544702gruffier
raffler13339222_raffler
affixer2033913__affixer
argufier1242113argufier
baffies153612943_baffies
baffler15418113_baffler
braggier12136453braggier
brainier102510233brainier
brakier133812363bra_kier
brannier10218933brannier
brashier13389933brashier
brasier94516753bra_sier
brassier103310533brassier
brattier1047663brattier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473bra_zier
buffier1568403_buffier
chaffer18389473chaff_er
chuffier1934543chuffier
cliffier1633913cliffier
crabbier14326803crabbier
crafter124111333cra_fter
craggier12116063craggier
crampier14288903crampier
crankier14339163crankier
crappier14288133crappier
crawlier13216873crawlier
crazier183610743cra_zier
daffed14429493d_aff_ed
daffiest1537843d_affiest
daffily1735133d_affily
daffing15369733d_affing
dafter104813343d_a_fter
dallier84215373d_allier
dandier93714573d_andier
darklier1335013darklier
dashier114311183d_ashier
daubier1037103d_aubier
deadlier1036863deadlier
deafer104114813dea_f_er
deffer134411303d_eff_er
defier105118653d__efier
deifier113013123d_eifier
differ133910843d_iff_er
doffer133911353d_off_er
drabber12438593dra_bber
draff125615663draff___
draffs13617903draff__s
draffy16486633draff__y
drafted12439033dra_fted
draftee11379523dra_ftee
draftees12225253draftees
drafters12338533dra_fters
draftiest1335943draftiest
draftily1534413draftily
drafting13339413drafting
dragger10309173dra_gger
dragster1034633dragster
drainer83012843dra_iner
draper94315693dra__per
drawer104711363dra__wer
drawler11338593dra_wler
dreamier11287293dreamier
drearier9297923drearier
dreggier1193553dreggier
dressier956863dressier
drier64423963dr___ier
drifter11348703dr_ifter
drippier1385043drippier
droolier936073droolier
droopier1145573droopier
drossier956313drossier
drowsier1284903drowsier
druggier11134833druggier
drumfire1442543drumfire
drumlier1134523drumlier
duffer134711663d_uff_er
dwarfer1433683dwarf_er
fluffier13264333fluffier
gaffer134310133_gaff_er
grabbier13316653grabbier
graffiti1542983graffiti
graffito1542873graffito
grafter114211153gra_fter
grainier9218903grainier
grapier103712603gra_pier
grassier9349283grassier
gratifier1345823gratifier
grazier173611133gra_zier
gruffer1475793gruff_er
huffier1637493_huffier
iffier1236763__iffier
kaffir16345303_kaffi_r
leafier10329833lea_fier
miffier1537023_miffier
orangier947713orangier
piaffer15104443piaff_er
proffer15126933proff_er
puffier1547973_puffier
quaffer2235133quaff_er
racier85120973_ra_cier
raffia12287703_raffi_a
raffias13237713_raffias
raffish1658843_raffish
raffle123910703_raffle_
raffled14429083_raffled
rafflers14317363_rafflers
raffles133611843_raffles
rafter94517583_ra_fter
rainier71614263_rainier
rallier73816273_rallier
rammier112811023_rammier
randier83618473_randier
rangier83714353_rangier
rapier84019993_ra_pier
rarefier1135353_rarefier
raspier93110643_raspier
ratifier1139673_ratifier
rattier74015593_rattier
reefier102912553_reefier
reifier103414523_reifier
riffler13328353_riffler
ruffler13369723_ruffler
rufflier1434013_rufflier
scruffier1743303scruffier
sniffier14356643sniffier
snuffier14276943snuffier
spiffier16255883spiffier
staffer13299093staff_er
stuffier14336623stuffier
taffies133012693_taffies
traffic1544733traffi_c
trafficker2251583trafficker
traffics1644183traffics
trampier12318243trampier
trashier113210103trashier
troffer13125863troff_er
waffie15338563_waffie_
waffies163611443_waffies
waffler16377783_waffler
wafflier1733953_wafflier
wrathier1435903wrathier
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.423422437.4
2DLD Change Limit1461621567.61019206.6
3Display Results1561560.0463391.3
 (SQL Overall)1786911568.07922118.0
 
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.