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

244 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
woopsing143563(None) 
cooping123918932coop_ing
coopting133411312coopting
goosing93314082goo_sing
hooping133615702hoop_ing
looping103615282loop_ing
loosing83515962loo_sing
noosing83315052noo_sing
pooping123615442poop_ing
roosing84018132roo_sing
swooping14338402swoop_ing
whooping17286632whoop_ing
whopping19357372whopping
wooding123012022woo_ding
woofing14349892woo_fing
wooing104214662woo__ing
wooshing1536682wooshing
adopting1237453adopting
apposing1337403apposing
arousing93811803arousing
biopsying1742453biopsying
blooping13248843bloop_ing
blousing1138793blousing
boobing123613913boo_bing
boodling121910243boodling
boogying1535373boogying
booing94521643boo__ing
booking143618383boo_king
booming123716223boo_ming
boosting113311053boosting
booting103821363boo_ting
boozing194012163boo_zing
bopping143512033_bopping
bossing103714603_bossing
bousing103718043_bousing
bowsing134012503_bowsing
browsing14319353browsing
choosing142010133choosing
chopping183710263chopping
chousing14259423chousing
chowsing17217343chowsing
clopping153511083clopping
closing103114843clo_sing
coapting133511613coapting
cohousing1535283cohousing
comping143518593comp_ing
composing16179843composing
compting153013603compting
cooeeing1137453cooeeing
cooeying1438143cooeying
cooing94024923coo__ing
cooking143818973coo_king
cooling103422573coo_ling
coopering142611323coopering
coping113927663_cop_ing
copping143918593_copping
copying153411983_copying
couping124317023coup_ing
coupling13310783coupling
coursing113112023coursing
cropping153210883cropping
crossing112612683crossing
deposing12129773deposing
doodling11218403doodling
dooming113112533doo_ming
doping103919463_dop_ing
dosing83920273_do_sing
dossing93313273_dossing
dousing93315763_dousing
dowsing123411123_dowsing
drooping12268803droop_ing
dropping14309283dropping
drowsing13287773drowsing
elapsing1146713elapsing
eloping103512833elop_ing
exposing1836673exposing
flopping16388773flopping
flossing12247903flossing
focusing1436603focusing
fooling113117373foo_ling
footing115017593foo_ting
footling12239923footling
foozling21275723foozling
fopping153511133_fopping
glopping14307753glopping
glossing10278883glossing
goofing123510633goo_fing
groping113313103grop_ing
grossing103111063grossing
grousing103410453grousing
hocusing1446583hocusing
hoising113414413_hoising
hooding123815203hoo_ding
hoofing143912553hoo_fing
hooking153716693hoo_king
hooting113919883hoo_ting
hoping123719743_hop_ing
hopping154115273_hopping
hoppling16206763hoppling
horsing113215583_horsing
hosing103421103_ho_sing
housing113316523_housing
imposing1348463imposing
iodising1037563iodising
iodopsin1143333iodopsin_
iodopsins1242943iodopsins
ionising9310223ionising
jonesing1636633jonesing
lapsing103511163_lapsing
looing73621043loo__ing
looking123415043loo_king
looming102814853loo_ming
looting83019643loo_ting
loping93921413_lop_ing
lopping123815223_lopping
losing74022873_lo_sing
louping104313983loup_ing
lousing83817733_lousing
mooching16259063mooching
mooing93718373moo__ing
mooning103415553moo_ning
mooring102514443moo_ring
mooting103019363moo_ting
moping114017103_mop_ing
mopping143411473_mopping
morphing1637553morphing
mossing103915423_mossing
mousing103816273_mousing
moussing1138143moussing
noising83615173_noising
nonusing939233nonusing
noodging11185693noodging
noodling10209443noodling
nooning83014853noo_ning
nosing73419843_no_sing
oohing104412933_oo_hing
oozing163812203_oo_zing
oping86322413__op_ing
opposing1336383_opposing
opsin7613473__opsin_
opsins8411713__opsins
opting94514403__opting
outsing83320463_outsing
peopling1338353peopling
plopping12318703plopping
poising103617103_poising
pooching16328983pooching
poohing133112323poo_hing
pooing93820683poo__ing
pooling103219093poo_ling
popping113715413_popping
poppling12227323poppling
posing93922643_po_sing
proposing1439673proposing
propping122811673propping
prosing103319383pro_sing
reposing111213803reposing
romping123113033romp_ing
roofing113814353roo_fing
rooking123517363roo_king
rooming104117043roo_ming
roosting93411463roosting
rooting83522433roo_ting
rootling9269953rootling
roping94023023_rop_ing
rosing73925593_ro_sing
rouping103715793roup_ing
rousing83920553_rousing
scooping133610633scoop_ing
scoping123513823scop_ing
shopping163611293shopping
sloping104114073slop_ing
slopping133811423slopping
snooping113811323snoop_ing
soaping103616223soap_ing
soothing12269973soothing
sooting82820963soo_ting
sopping123917203_sopping
souping104215533soup_ing
sousing83517823_sousing
spousing11198733spousing
stooping113012363stoop_ing
stoping103716623stop_ing
stopping133611413stopping
swooning12278203swoo_ning
swooshing1643883swooshing
swopping16377963swopping
tooling82918313too_ling
toothing12278863toothing
tooting83019423too_ting
tootling9279523tootling
toping94122993_top_ing
topping123514623_topping
toppling13197353toppling
tossing83612563_tossing
tousing82916993_tousing
trooping112710283troop_ing
wapping153514603w_apping
warping133715183warp_ing
weeping133613673weep_ing
whapping19317113whapping
whipping19328173whipping
whomping19285943whomping
whoofing18234833whoofing
whooshing1943213whooshing
whoring142910293who_ring
whupping19345243whupping
wimping153911013wimp_ing
wimpling16207483wimpling
wiping123916713w_ip_ing
wising103318223w__ising
wisping133711943wisp_ing
wissing113212943w_issing
wobbling16246923wobbling
wolfing14277893w_olfing
womaning1437643womaning
wonning113210793w_onning
wonting113214103w_onting
woodbin1354873woodbin_
woodbind1543713woodbind
woodbine1444973woodbine
woodbins1445043woodbins
woodsia1144173woodsi_a
woodsias1244923woodsias
woodsier1245473woodsier
woodwind1643753woodwind
woolskin1543013woolskin_
woolskins1643003woolskins
woops104917523woops___
woopsed1344733woops_ed
woopses1237883woops_es
wording123014563w_ording
working153813253w_orking
worming132811243w_orming
worrying1534703worrying
worsting1267683worsting
worthing15178053worthing
wotting112913843w_otting
wounding13249403wounding
wowing133915393w_o_wing
wrapping16297623wrapping
wronging13327393wronging
zooming19269653zoo_ming
zooning172910703zoo_ning

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.423422437.4
2DLD Change Limit1461622446.79621507.1
3Display Results2442440.0932623.7
 (SQL Overall)1786912447.31224438.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.