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

398 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
grifting1329926(None) 
drifting13338731drifting
gifting123810891g_ifting
grafting13319621grafting
gritting10309981gritting
rifting113515001_rifting
crafting143710172crafting
drafting13339402drafting
fritting123510702fritting
gaiting93716582gai_ting
girting93113332g_irting
gitting93215702g_itting
glinting103210052glinting
granting103514522granting
grating93923182gr_ating
greeting103112352greeting
griding103014972gri_ding
grieving1385892grieving
griffin1434512griffin_
griffins1544782griffins
grilling103811532grilling
griming113612492gri_ming
grinding1139862grinding
grinning1037862grinning
griping113012062gri_ping
gripping14277542gripping
grouting103410792grouting
gruffing1635272gruffing
grunting10269582grunting
lifting113313272_lifting
printing113216082printing
rafting113815752_rafting
riffing144011272_riffing
rifling112815012_rifling
rioting82716392_rioting
shifting152910382shifting
sifting113014592_sifting
trifling122411502trifling
writing113713892wri_ting
aerifying1636493aerifying
agisting1038243agisting
airlifting1443343airlifting
airting83616303_airting
arising83619973ari_sing
arointing1049363arointing
aviating12311013aviating
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
deifying1637633deifying
dieting93616833_dieting
dinting93520553_dinting
draftings14334203draftings
dratting10389653dratting
dribbing14325883dribbing
driftier1275123driftier
driftingly1843663driftingly
driftpin1441843driftpin_
driftpins1541833driftpins
drilling103311983drilling
drinking14308913drinking
dripping14278033dripping
driving123910713dri_ving
edifying1636083edifying
editing9313133edi_ting
emitting112410353emitting
engrafting1544183engrafting
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
gaffing15379733g_affing
gaining94015663gai_ning
garoting10510703garoting
garotting1136103garotting
garroting1136953garroting
gasifying1744523gasifying
gasting95022763g_asting
gating84826953g__ating
gelating103015733gelating
getting93316563g_etting
ghosting1336463ghosting
gibbing13339373g_ibbing
gibing103712353g_i_bing
gieing83614853g_i_eing
gigging93311773g_igging
gilding103813003g_ilding
gilling93520383g_illing
gimping133710763g_imping
ginning93313983g_inning
gipping133813123g_ipping
girding103611883g_irding
girdling1146823girdling
girning93210693g_irning
girthing13256083girthing
gittin72910553g_ittin_
giving114313883g_i_ving
gleeting10279173gleeting
gliding103911843gli_ding
gliming113310133gli_ming
glitzing1934973glitzing
gloating102611463gloating
glorifying1843673glorifying
glouting10379693glouting
glutting10247643glutting
golfing12368943golf_ing
goofing123510633goof_ing
grabbing14267313grabbing
gracing113216443gr_acing
gradating1237313gradating
grading103918713gr_ading
graffiting1842923graffiting
graining102813183graining
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
gratifying1874213gratifying
gratin74520583gr_atin_
gratine84719193gr_atine
gratings103910763gr_atings
gratins84119183gr_atins
graving123114563gr_aving
graying124115883gr_aying
grayling1338003grayling
grazing183514553gr_azing
greasing102811393greasing
greeing93613783gr_eeing
greening103112533greening
greetings11276043greetings
greying124110893gr_eying
griddling1333933griddling
griffon1443103griffon_
griffons1542573griffons
grift95924463grift___
grifted12379583grift_ed
grifter113810493grift_er
grifters12389233grifters
grifts104511683grift__s
grimacing1544033grimacing
griskin1236013griskin_
griskins1335953griskins
grittier9316263grittier
grittily1244183grittily
grizzling1942843grizzling
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gr_oping
grossing103111063grossing
grouping12308533grouping
grousing103410453grousing
growing123512473gr_owing
growling1348163growling
grubbing14295403grubbing
grudging12255993grudging
grueling1078273grueling
grumping14266903grumping
gruntling1134263gruntling
guesting1058463guesting
guiding102911843gui_ding
guiling93214213gui_ling
guising93511413gui_sing
gulfing12339473gulf_ing
gusting93917163g_usting
gutting93415923g_utting
gyrating1337453gyrating
hafting144014173_hafting
hefting144510913_hefting
heisting123411043heisting
hilting113316893_hilting
hinting113919223_hinting
histing113720373_histing
hitting113017273_hitting
hoisting123610903hoisting
ignifying1744313ignifying
igniting1037363igni_ting
ingrafting1544893ingrafting
irising83614423iri_sing
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
kilting123213853_kilting
kiting114117093_ki_ting
kitting123214443_kitting
knifing1536483knif_ing
knitting13257023knitting
lariating10311783lariating
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
lofting113311313_lofting
meriting11314683meri_ting
miffing16298403_miffing
milting103619123_milting
minting103020813_minting
misting103623383_misting
nigrifying1843843nigrifying
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
printings12268103printings
prising103321453pri_sing
prissing113011453prissing
pristine10313503pristine
prizing193514683pri_zing
profiting1549983profiting
purifying1835853purifying
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quitting18228833quitting
ranting84025413_ranting
rarifying1646313rarifying
rating74938703_r_ating
ratting83822363_ratting
reffing143712173_reffing
refuting121911903_refuting
regrafting1545993regrafting
reifying1539383reifying
renting84026853_renting
resifting133512093resifting
resting85031183_resting
retting83425883_retting
ribbing123111953_ribbing
ricing94822763_ri_cing
ricking143920233_ricking
ridding103314193_ridding
ridging104112983_ridging
riding84325963_ri_ding
riffling1556113_riffling
riflings12227303_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
triflings13235973triflings
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tri_ning
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
trotting92510913trotting
trusting93411653trusting
trysting12267053trysting
tufting11289873_tufting
twisting12427813twisting
twitting12307223twitting
uglifying1743963uglifying
unifying1537553unifying
uniting8315823uni_ting
uplifting1534963uplifting
urinating10310653urinating
variating13310943variating
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 7 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.1561145455.1
2DLD Change Limit1461623986.59322169.3
3Display Results3983980.1562551.3
 (SQL Overall)1786913986.90525878.5
 
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.