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

410 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
drifting1333873(None) 
drafting13339411drafting
grifting13299261grifting
rifting113515001_rifting
crafting143710172crafting
deifying1637632deifying
dieting93616832d_ieting
dinting93520552d_inting
draftings14334212draftings
dratting10389662dratting
dribbing14325882dribbing
driftier1275122driftier
driftingly1843672driftingly
driftpin1441842driftpin_
driftpins1541832driftpins
drilling103311982drilling
drinking14308912drinking
dripping14278032dripping
driving123910712dri_ving
fritting123510702fritting
gifting123810892_gifting
grafting13319622grafting
gritting10309982gritting
lifting113313272_lifting
printing113216082printing
rafting113815752_rafting
riffing144011272_riffing
rifling112815012_rifling
rioting82716392_rioting
shifting152910382shifting
sifting113014592_sifting
trifling122411502trifling
writing113713892wri_ting
addicting1485073addicting
admitting1345033admitting
aerifying1636493aerifying
agisting1038243agisting
airlifting1443343airlifting
airting83616303_airting
arising83619973ari_sing
arointing1049363arointing
aviating12311023aviating
baiting103918883bai_ting
biffing163510013_biffing
biting95321823_bi_ting
bitting103717293_bitting
bribing123111043bri_bing
bricking173911403bricking
bridging13288443bridging
bridling122610583bridling
briefing1436943briefing
brimming15196623brimming
bringing123011273bringing
brining103216473bri_ning
brisking15329473brisking
brisling112410843brisling
bristling1246663bristling
brittling1235543brittling
bruiting11259973bruiting
bruting102612993br_uting
citing94220183_ci_ting
clefting14347583clefting
coiffing1755933coiffing
coifing133213893coif_ing
crating103725203cr_ating
creating113921953creating
cresting114017043cresting
cribbing15276843cribbing
cricking173412653cricking
crimping15299783crimping
cringing123311383cringing
crisping13319663crisping
crusting113612793crusting
daffing15369733d_affing
dairying1336353dairying
darting94020663d_arting
dating85326483d__ating
daunting103310403daunting
dauting93814763d_auting
dawting123610673d_awting
debating123213733debating
debiting122511203debiting
debuting12268633debuting
defiling132812463defiling
defining133711803defining
defying15328823d_efying
deicing11312193dei_cing
deigning1137753deigning
delating103119603delating
deleting103314423deleting
delisting112710503delisting
demitting13239073demitting
demoting12311423demoting
denoting10311753denoting
denting94422183d_enting
depicting1537813depicting
deputing12238793deputing
derating103222283derating
deratting1139513deratting
deriding112512933deri_ding
deriving132510743deri_ving
desisting112810383desisting
deviating14311083deviating
devoting1338823devoting
dialing94318173d_ialing
dibbing133110893d_ibbing
dicing105718763d_i_cing
dicking153617613d_icking
dieing84018653d_i_eing
digging113513703d_igging
dighting142510843dighting
diking124320243d_i_king
dilating102714913dilating
diluting10248983diluting
dimming13339593d_imming
dinging103618613d_inging
dining84525133d_i_ning
dinking133618283d_inking
dinning93416553d_inning
dipping134014833d_ipping
directing1338823directing
dirking133812603d_irking
dirling93316073d_irling
dirtying1336093dirtying
discing113914593d_iscing
dishing124017103d_ishing
disking134615493d_isking
dissing94517683d_issing
dittoing1036263d_ittoing
diving113717953d_i_ving
doating93816863d_oating
doffing15357793d_offing
donating10311803donating
doting84821913d__oting
dotting93314483d_otting
doubting1237373doubting
drabbing14286803drabbing
draftier1285263draftier
draftily1534413draftily
dragging12308103dragging
draining103312673draining
dramming14347573dramming
draping114213353dr_aping
drawing123812053dr_awing
drawling13318673drawling
draying123813843dr_aying
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dr_eeing
dressing102810423dressing
dribbling1533713dribbling
drift95722843drift___
driftage1342933driftage
drifted12367953drift_ed
drifter11348703drift_er
drifters12417913drifters
driftiest1335943driftiest
drifts10499893drift__s
drifty13418223drift__y
drillings11285823drillings
drinkings15244773drinkings
drippings15313903drippings
driveling1445763driveling
drivings13265763dri_vings
drizzling1943023drizzling
drolling103510763drolling
droning93013723dr_oning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dr_oving
drowning13298363drowning
drowsing13287773drowsing
drubbing14286053drubbing
drudging12256233drudging
drugging12326443drugging
drumming14265783drumming
drying113411603dr__ying
ducting113713593d_ucting
dueting93814393d_ueting
duetting1047183duetting
dunting93418383d_unting
dusting93618993d_usting
dwining12269293dwi_ning
edifying1636083edifying
editing9313133edi_ting
emitting112410353emitting
erecting112415063erecting
eructing112110173eructing
erupting11218443erupting
evicting1437483evicting
eviting11511373evi_ting
existing1639073existing
exiting15311393exi_ting
fainting123312163fainting
feinting123410833feinting
fifing134212343_fif_ing
fisting113818123_fisting
fitting113516563_fitting
flinting123412343flinting
flirting12319013flirting
fliting113514613fli_ting
flitting123010883flitting
foisting122910503foisting
fretting122711523fretting
frigging14268953frigging
frighting1736023frighting
frilling123011493frilling
fringing133010903fringing
frisking16268363frisking
frizing203310873fri_zing
frizzing2064803frizzing
fronting12310443fronting
frosting12311183frosting
fruiting12229063fruiting
gaiting93716583gai_ting
girting93113333_girting
gitting93215703_gitting
glinting103210053glinting
granting103514523granting
grating93923183gr_ating
greeting103112353greeting
griding103014973gri_ding
grieving1385893grieving
griffin1434513griffin_
griffins1544783griffins
grilling103811533grilling
griming113612493gri_ming
grinding1139863grinding
grinning1037863grinning
griping113012063gri_ping
gripping14277543gripping
grouting103410793grouting
gruffing1635273gruffing
grunting10269583grunting
hafting144014173_hafting
hefting144510913_hefting
heisting123411043heisting
hilting113316893_hilting
hinting113919223_hinting
histing113720373_histing
hitting113017273_hitting
hoisting123610903hoisting
irising83614423iri_sing
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
kilting123213853_kilting
kiting114117093_ki_ting
kitting123214443_kitting
knifing1536483knif_ing
knitting13257023knitting
lariating10311793lariating
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
lofting113311313_lofting
meriting11314693meri_ting
miffing16298403_miffing
milting103619123_milting
minting103020813_minting
misting103623383_misting
omitting11217743omitting
opiating11410093opiating
orating83520323or_ating
orbiting1138153orbiting
orienting1038723orienting
painting113614423painting
pirating11314513pirating
pitting103618873_pitting
pointing112813683pointing
prating103424453pr_ating
presifting1638083presifting
pricing123417343pri_cing
pricking173212603pricking
priding113317543pri_ding
priesting1239483priesting
prigging13299093prigging
prilling113413413prilling
priming123417373pri_ming
primming15268173primming
primping15338893primping
prinking153212453prinking
printings12268113printings
prising103321453pri_sing
prissing113011453prissing
pristine10313503pristine
prizing193514683pri_zing
profiting1549983profiting
purifying1835853purifying
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quitting18228833quitting
ranting84025413_ranting
rarifying1646313rarifying
rating74938703_r_ating
ratting83822363_ratting
redrafting1545963redrafting
reffing143712173_reffing
refuting121911903_refuting
reifying1539383reifying
renting84026853_renting
resifting133512093resifting
resting85031183_resting
retting83425883_retting
ribbing123111953_ribbing
ricing94822763_ri_cing
ricking143920233_ricking
ridding103314193_ridding
ridging104112983_ridging
riding84325963_ri_ding
riffling1556113_riffling
riflings12227313_riflings
rigging103016333_rigging
righting132610853_righting
riling74227973_ri_ling
rilling84023623_rilling
riming93322223_ri_ming
rimming123411073_rimming
ringing93521283_ringing
rinning83216743_rinning
rinsing82516113_rinsing
riping93821613_ri_ping
ripping123315743_ripping
rising74025883_ri_sing
risking123914243_risking
riveting12139443_riveting
riving104521423_ri_ving
rooting83522433_rooting
rotting82919683_rotting
routing83821093_routing
ruffing143210843_ruffing
rusting83821263_rusting
rutting82718043_rutting
sainting93215733sainting
scripting1437473scripting
seriating10916403seriating
shafting15278683shafting
shirting123213613shirting
shitting123212663shitting
siftings12236583_siftings
silting83320483_silting
siting74126623_si_ting
sitting83519633_sitting
skirting13289393skirting
skiting123812503ski_ting
slitting93012583slitting
smiting103014443smi_ting
sniffing15227453sniffing
spiffing17237083spiffing
spirting112913633spirting
spiting103917623spi_ting
spitting113012323spitting
sprinting12310033sprinting
stiffing15248703stiffing
stifling122110913stifling
stilting93312403stilting
stinting93415743stinting
striating10914193striating
suiting83419003sui_ting
tainting93613583tainting
tariffing1644113tariffing
tiffing14339383_tiffing
tilting83417103_tilting
tinting84620603_tinting
toiting83217093toi_ting
treating92519613treating
triaging102610543triaging
tricing103417353tri_cing
tricking152714513tricking
triflings13235983triflings
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tri_ning
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
trotting92510913trotting
trusting93411653trusting
trysting12267053trysting
tufting11289873_tufting
twisting12427813twisting
twitting12307223twitting
unifying1537553unifying
uniting8315823uni_ting
uplifting1534963uplifting
urinating10310653urinating
variating13310953variating
verifying1936413verifying
wafting143911663_wafting
waifing142910893waif_ing
waisting123615213waisting
waiting113618953wai_ting
whiffing2134703whiffing
whisting15329543whisting
whiting143311303whi_ting
wifing133513393_wif_ing
wilting113515913_wilting
wisting113519743_wisting
witing103522823_wi_ting
witting113417063_witting
wresting123811833wresting
wricking18349493wricking
wringing13279623wringing
writhing15278673writhing
writings12298113wri_tings

Search took 10 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.470380193.6
2DLD Change Limit1461624108.51617163.2
3Display Results4104100.3731099.2
 (SQL Overall)1786914109.35919093.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.