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

381 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
poaching16351083(None) 
coaching164011961coaching
peaching163613641peaching
pooching16328981pooching
pouching163210411pouching
roaching143210431roaching
aching126521972__aching
baching156017752_baching
beaching164114142beaching
botching16359702botching
broaching17287662broaching
caching156317502_caching
coacting133412692coacting
couching163213262couching
douching15349842douching
hotching17309312hotching
leaching143012832leaching
loathing1247672loathing
mooching16259062mooching
mouching163110582mouching
notching14288582notching
ouching134314902_ouching
pacing114522752p_ac_ing
packing164420722p_acking
parching164313052parching
pashing135120512p_ashing
patching163212752patching
peacing124117072peac_ing
peching154513902p_eching
perching163711632perching
pinching163711052pinching
pitching163411112pitching
placing123815282plac_ing
plashing143311062plashing
pleaching17257082pleaching
poachier1556822poachier
pocking163916762po_cking
poncing122913582ponc_ing
poohing133112322po_ohing
preaching172811162preaching
psyching1934482psyching
punching163310122punching
reaching143317202reaching
teaching143612602teaching
torching142510082torching
touching143211342touching
vouching17308232vouching
aahing1019015763__aahing
abashing1466623abashing
acing87429153__ac_ing
acting95920983__acting
ahing98928343__a_hing
approaching2162453approaching
arching136216693_arching
ashing107824093__ashing
attaching1545433attaching
avouching1843273avouching
backing165523443_backing
bashing135422583_bashing
batching163712093batching
bathing134816243_bathing
belching16349153belching
benching163411343benching
birching16328463birching
bitching163610623bitching
blacking174213603blacking
blanching17297093blanching
bleaching17287093bleaching
blotching1734963blotching
boarding123110233boarding
boasting113512493boasting
boating103721303boa_ting
bracing123817613brac_ing
branching17289263branching
breaching17269403breaching
bunching163410703bunching
cashing135022553_cashing
catching163712773catching
cinching163310223cinching
clacking173313493clacking
clashing143812193clashing
coaling103722823coa_ling
coaming123818323coa_ming
coapting133511603coapting
coasting113615503coasting
coating103525303coa_ting
coaxing173511703coa_xing
cochin131313203co_chin_
cochins141413093co_chins
cocking163619983co_cking
coshing134316433co_shing
couchings17285753couchings
coughing15309213coughing
cracking174013903cracking
cranching17278733cranching
crashing143512633crashing
crouching1746383crouching
dashing125917893_dashing
deashing134210953deashing
detaching1637263detaching
ditching15349943ditching
doating93816863doa_ting
docking153615013do_cking
eching126315563__eching
enacting11311363enacting
etching134511843_etching
exacting1838523exacting
facing125321573_fac_ing
fashing144918793_fashing
fetching17298413fetching
filching1736113filching
flacking184311793flacking
flashing153711553flashing
foaling113515843foa_ling
foaming133612993foa_ming
forcing134013753forc_ing
gashing125119233_gashing
glaceing1236533glaceing
gnashing1336423gnashing
goading103112853goa_ding
goaling93515333goa_ling
gracing113216443grac_ing
graphing1538533graphing
grouching1644943grouching
hacking173720613_hacking
hashing145020163_hashing
hatching173312213hatching
hitching173310523hitching
hoarding13288643hoarding
hoaxing18307763hoa_xing
hocking173417243ho_cking
hoicking1836053hoicking
honchoing1844873honchoing
hunching17309113hunching
hutching17318643hutching
impeaching2043373impeaching
inarching1546343inarching
inching134414323_inching
itching134011683_itching
jacking214515263_jacking
joshing18519413jo_shing
kachina1637663_kachina
knacking14296713knacking
lacing94626233_lac_ing
lacking143821543_lacking
lashing114422893_lashing
latching143712023latching
lathing114315693_lathing
leashing123310313leashing
leching134613653_leching
leeching14318373leeching
letching143810263letching
loading94114613loa_ding
loafing11319793loa_fing
loaming103613733loa_ming
loaning83614833loa_ning
loathings1344213loathings
locating11311503locating
locking143718153lo_cking
locoing102810973lo_coing
lunching143110003lunching
lurching14277333lurching
lynching17336083lynching
machine14313493_machine
macing114221553_mac_ing
marching164312193marching
mashing134422243_mashing
matching163512393matching
miching152911803_miching
moaning103714443moa_ning
moating104218153moa_ting
mocking163614453mo_cking
morphing1637553morphing
moshing134214883mo_shing
mouthing142810243mouthing
mulching16287103mulching
munching16299973munching
niching133612433_niching
nocking143615113no_cking
nonacting1238783nonacting
noncling11310763noncling
northing12199063northing
noshing114612773no_shing
nothing113511903no_thing
oaring74225303_oa_ring
ochring13156673_o_chring
ohing96018803_o__hing
oohing104412933_o_ohing
opaquing2042313opaquing
pachinko1942303p_achinko
pachisi14329523p_achisi
packings174310063p_ackings
padding123412513p_adding
paging104020403p_a_ging
paiking143814813p_aiking
paining103920243p_aining
pairing103716733p_airing
paling93530133p_a_ling
palling104024483p_alling
palming123914013p_alming
palping124112873p_alping
panging113319113p_anging
panning104019393p_anning
panting104025423p_anting
parging113318603p_arging
paring94236493p_a_ring
parking143423043p_arking
parling103823763p_arling
parring103222063p_arring
parsing103819553p_arsing
parting103527383p_arting
passing104318423p_assing
pasting103826553p_asting
patting103722343p_atting
pausing103912813p_ausing
paving124519743p_a_ving
pawing124519553p_a_wing
pawning134711413p_awning
paying123722163p_a_ying
peachier1548623peachier
peaking144317683pea_king
pealing104123203pea_ling
pearling11912003pearling
pecking164017783p_ecking
pharming16248143pharming
phasing133211673pha_sing
piaffing1733923piaffing
picking163418333p_icking
piecing12410453piec_ing
pishing134314373p_ishing
pithing134014053p_ithing
placating1438513placating
plaguing1236033plaguing
plaining113911553plaining
plaiting113113513plaiting
planing103418253pla_ning
planking153513013planking
planning113610223planning
planting113515383planting
plating103823073pla_ting
platting114813033platting
playing133816093pla_ying
plaything1843853plaything
ploughing16203673ploughing
plucking17357723plucking
poach124917863poach___
poached154212403poach_ed
poacher143912323poach_er
poachers152910763poachers
poaches144416943poach_es
poachiest1636883poachiest
poachy16388963poach__y
podding124113183po_dding
poinding122510003poinding
pointing112813683pointing
poising103617103po_ising
poking133819303po__king
policing13311673policing
poling93526503po__ling
polishing1536923polishing
polkaing1534633polkaing
polling102920383po_lling
pomading1437423pomading
ponding114317083po_nding
ponging113416153po_nging
ponying133312123po_nying
pooing93820683po__oing
pooling103219093po_oling
pooping123615443po_oping
popping113715413po_pping
poppling12227323poppling
porcine11312843porc_ine
porcini1137633porc_ini
porcino1138113porc_ino
poring94227273po__ring
porking143515813po_rking
porting103021783po_rting
posing93922643po__sing
positing11312303positing
posting105622243po_sting
potlatching1952113potlatching
potting103720893po_tting
pouchier1546803pouchier
pouncing13318883pouncing
pounding123311473pounding
pouring103115863po_uring
pouting103519943po_uting
powering142210803powering
poxing163714943po__xing
praising113214563praising
prancing132612163prancing
pranging123012723pranging
pranking153813383pranking
prating103424453pra_ting
prawning1446963prawning
praying133717323pra_ying
preacting142412533preacting
pricing123417343pric_ing
pricking173212603pricking
psalming1375473psalming
pushing133615453p_ushing
quacking2436743quacking
quashing2137093quashing
racing95030533_rac_ing
racking144323663_racking
ranching141712043ranching
reacting113317893reacting
reproaching1944303reproaching
retching143412173retching
roaming103215793roa_ming
roaring82916003roa_ring
roasting93012693roasting
rocking143619633ro_cking
roughing13278343roughing
ruching133612933_ruching
sacking144122703_sacking
sacring103115983_sacring
sashing114621473_sashing
scathing14269703scathing
scooching1735073scooching
scorching1735633scorching
scotching1735653scotching
searching1538343searching
shacking184014083shacking
slacking153914133slacking
slashing123713413slashing
slouching15195723slouching
smacking173510763smacking
smashing143310243smashing
smooching1734883smooching
snacking153411703snacking
snatching1536363snatching
soaking123116613soa_king
soaping103616223soa_ping
soaring83521893soa_ring
socking143518603so_cking
solacing11310133solac_ing
soochong14104373soochong
soothing12269963soothing
souchong1484513souchong
soughing13259733soughing
southing122811823southing
spacing123614493spac_ing
splashing1535703splashing
splotching1842863splotching
stacking154215083stacking
stanching1538083stanching
starching1538593starching
stashing123511583stashing
stomaching1844313stomaching
swashing15369743swashing
swathing15248713swathing
synching17227713synching
tacking144421483_tacking
teachings15296553teachings
thacking183110043thacking
thatching1835143thatching
toadying1335043toadying
toasting93410573toasting
toothing12278863toothing
toughing13278553toughing
trachling1537823trachling
tracing103720153trac_ing
tracking153715463tracking
trashing122613223trashing
upreaching1844113upreaching
voicing13279083voic_ing
washing145119283_washing
watching173011173watching
welching17287363welching
wenching17328863wenching
whacking21377483whacking
winching17359903winching
witching173410633witching
wooshing1536683wooshing
worthing15178053worthing
wracking18349963wracking
wrathing15248923wrathing
yachting1734933_yachting
yacking174315683_yacking
yocking173712373yo_cking

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.1561145455.1
2DLD Change Limit1461623818.50017195.5
3Display Results3813810.1562442.3
 (SQL Overall)1786913818.81220278.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.