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

248 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
dittoing103626(None) 
bitting103717292bitt_ing
dieting93616832diet_ing
dinting93520552dint_ing
dirtying1336092dirtying
discoing12511452discoing
ditching15349942ditching
dotting93314482dott_ing
fitting113516562fitt_ing
gitting93215702gitt_ing
hitting113017272hitt_ing
kitting123214442kitt_ing
kittling1336062kittling
lithoing1236742lithoing
pitting103618872pitt_ing
sitting83519632sitt_ing
vittling1236142vittling
witting113417062witt_ing
admitting1345033admitt_ing
airthing12297953airthing
airting83616303airt_ing
autoing8314043_autoing
batting104422273batt_ing
battling113110493battling
betting103921403bett_ing
biltong1034683bilto_ng
birthing14338433birthing
bitching163610623bitching
bitewing1435293bitewing
biting95321823bi_t_ing
bittering122511993bittering
bittings11339293bitt_ings
bottling11279143bottling
bottoming1444433bottoming
brittling1235543brittling
butting103519283butt_ing
buttoning1246463buttoning
catting103922643catt_ing
citing94220183ci_t_ing
cottoning1237343cottoning
cuittling1234103cuittling
cutting103817493cutt_ing
cuttling1138203cuttling
dadoing1038523d_adoing
darting94020663dart_ing
dartling1039563dartling
dating85326483d_at_ing
dauting93814763daut_ing
dawting123610673dawt_ing
demitting13239073demitt_ing
demoing11311753d_emoing
demoting12311423demoting
denoting10311753denoting
denting94422183dent_ing
detoxing1736313detoxing
devoting1338823devoting
dialing94318173di_aling
dialling10310783dialling
dialoging1246313dialoging
diatonic1138673diatonic
dibbing133110893di_bbing
dibbling14247333dibbling
dicing105718763di__cing
dicking153617613di_cking
dictating1338883dictating
diction102313053diction_
dictions111812673dictions
diddling12228743diddling
dieing84018653di__eing
digging113513703di_gging
dighting142510843dighting
diking124320243di__king
dilating102714903dilating
diluting10248983diluting
dimming13339593di_mming
dimpling14199023dimpling
dindling112411163dindling
dinging103618613di_nging
dining84525133di__ning
dinking133618283di_nking
dinning93416553di_nning
dipping134014833di_pping
dirking133812603di_rking
dirling93316073di_rling
discing113914593di_scing
dishing124017103di_shing
disjoin1547643disjoin_
disjoins1647623disjoins
disjoint1649233disjoint
disking134615493di_sking
disposing1339933disposing
disrobing1347703disrobing
dissing94517683di_ssing
distain8313783distain_
distains9413603distains
distorting1239583distorting
disusing1039003disusing
disyoking1844993disyoking
dithering1499853dithering
dittany1135653ditt_any
ditties83116983ditt_ies
ditto65315603ditto___
dittoed936733ditto_ed
dittos74111973ditto__s
dividing1437183dividing
diving113717953di__ving
divining1338413divining
divvying1932773divvying
dizening19177143dizening
dizzying2133023dizzying
doating93816863doat_ing
doctoring1346183doctoring
doing74923583d___oing
doting84821913d_ot_ing
dratting10389653dratting
drifting13338733drift_ing
ducting113713593duct_ing
dueting93814393duet_ing
duetting1047183duetting
dunting93418383dunt_ing
dusting93618993dust_ing
editing9313133edi_t_ing
emitting112410353emitt_ing
fatting113818703fatt_ing
fetting113517873fett_ing
fettling1266773fettling
fisting113818123fist_ing
fittings12318203fitt_ings
flitting123010883flitt_ing
fritting123510703fritt_ing
getting93316563gett_ing
ghettoing1442123ghettoing
gifting123810893gift_ing
girthing13256083girthing
girting93113333girt_ing
gittin72910553gitt_in_
gritting10309983gritt_ing
gutting93415923gutt_ing
guttling1037293guttling
hatting113920233hatt_ing
hilloing12158303hilloing
hilting113316893hilt_ing
hinting113919223hint_ing
histing113720373hist_ing
hitching173310523hitching
hotting113116523hott_ing
hutting113016033hutt_ing
ingoing9311023_ingoing
intoning9311123_intoning
itching134011683_itching
iteming1037753_iteming
jetting153815343jett_ing
jettying1933953jettying
jilting153211743jilt_ing
jittering17218423jittering
jotting152912773jott_ing
jutting153313713jutt_ing
juttying1933573juttying
kilting123213853kilt_ing
kithing153411553ki_thing
kiting114117093ki_t_ing
kitling123313573ki_tling
kittening1434593kittening
knitting13257023knitt_ing
letting83218533lett_ing
lifting113313273lift_ing
lilting83515383lilt_ing
linting83820983lint_ing
listing84020593list_ing
littering102411983littering
lotting82917753lott_ing
matting103620143matt_ing
milting103619123milt_ing
mimeoing1336143mimeoing
minting103020813mint_ing
misdoing1238803misdoing
misting103623383mist_ing
mitering113015403mitering
mitring103514143mi_tring
mottling11197753mottling
netting84018763nett_ing
nettling957213nettling
nutting83316233nutt_ing
omitting11217743omitt_ing
outdoing1039423outdoing
outgoing1039273outgoing
patting103722343patt_ing
petting103720953pett_ing
pettling1168213pettling
photoing1439073photoing
picoting1338883picoting
piloting1139693piloting
pistoling1268493pistoling
pitching163411113pitching
pithing134014053pi_thing
pittings11349123pitt_ings
pitying132910243pi_tying
pivoting1436183pivoting
potting103720893pott_ing
putting103218573putt_ing
puttying1434953puttying
quitting18228833quitt_ing
ratting83822363ratt_ing
rattling92510873rattling
retting83425883rett_ing
rifting113515003rift_ing
rioting82716393riot_ing
rotting82919683rott_ing
rutting82718043rutt_ing
setting83621393sett_ing
settling978943settling
shitting123212663shitt_ing
sifting113014593sift_ing
siloing83215503si_loing
silting83320483silt_ing
siting74126623si_t_ing
sittings9339733sitt_ings
slitting93012583slitt_ing
spitting113012323spitt_ing
tatting84019523tatt_ing
tattling9259473tattling
tattooing1043963tattooing
tilting83417103tilt_ing
tinting84620603tint_ing
tiptoeing1242713tiptoeing
tithing113513893ti_thing
titling83715793ti_tling
tittering102310313tittering
tittuping1242453tittuping
toting74123793__toting
totting82816843tott_ing
tutting83515913tutt_ing
twitting12307223twitt_ing
vatting113614853vatt_ing
vetoing11309053_vetoing
vetting114216563vett_ing
wattling12258783wattling
wetting114117383wett_ing
whittling1634383whittling
wilting113515913wilt_ing
wintling12249923wintling
wisting113519743wist_ing
witching173410633witching
withing143814493wi_thing
witing103522823wi_t_ing
witling113215813wi_tling
wittings12328733witt_ings
wotting112913843wott_ing

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.1531167915.0
2DLD Change Limit1461622487.62619166.3
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.87222699.6
 
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.