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

172 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
scrooping144659(None) 
scooping133610631sc_ooping
cooping123918932_c_ooping
crooking153611342_crooking
crooning113112112_crooning
cropping153210882_cropping
drooping12268802_drooping
schooling1546942schooling
scooting113012642sc_ooting
scoping123513822sc__oping
scraping133310862scr_aping
scrapping1635742scrapping
scrimping1634952scrimping
scrolling12187802scrolling
scrooching1843322scrooching
scrouging1335262scrouging
snooping113811322s_nooping
stooping113012362s_tooping
stropping1436932stropping
swooping14338402s_wooping
trooping112710282_trooping
blooping13248843_blooping
brooding122911373_brooding
brooking153710703_brooking
brooming132911143_brooming
chomping18339883_chomping
choosing142010133_choosing
chopping183710263_chopping
clomping15329653_clomping
clopping153511083_clopping
comping143518593_c_omping
cooing94024923_c_oo_ing
cooking143818973_c_ooking
cooling103422573_c_ooling
coopting133411313_c_oopting
coping113927663_c__oping
copping143918593_c_opping
couping124317023_c_ouping
cramping153411853_cramping
craping124018713_cr_aping
crapping153911453_crapping
creeping133310103_creeping
creping122913653_cr_eping
crimping15299783_crimping
crisping13319663_crisping
croaking153712163_croaking
crocking174313443_crocking
crossing112612683_crossing
crowding15247933_crowding
crowing133814763_cr_owing
crowning143510033_crowning
crumping15319903_crumping
drooling102610423_drooling
dropping14309283_dropping
enrooting10128133enrooting
escaloping1543723escaloping
escrowing1544813escr_owing
grooming12309513_grooming
grooving13286713_grooving
groping113313103_gr_oping
grouping12308533_grouping
hooping133615703__hooping
looping103615283__looping
marooning1238593marooning
pooping123615443__pooping
proofing1439313_proofing
propping122811673_propping
reroofing1336863reroofing
romping123113033__romping
roofing113814353__roofing
rooking123517363__rooking
rooming104117043__rooming
roosing84018133__roosing
rooting83522433__rooting
roping94023023__r_oping
rouping103715793__rouping
scalloping1543953scalloping
scalping133410453sc_alping
scamping153510193sc_amping
scaping123715693sc__aping
scarping133312463sc_arping
schmoosing1843143schmoosing
schmoozing2742723schmoozing
schoolings1644013schoolings
scoffing17275943sc_offing
scolding12278913sc_olding
scolloping1543243scolloping
sconcing1338263sc_oncing
scooching1735073scooching
scorching1735633scorching
scoring103117213sc__oring
scorning1169133sc_orning
scouring112810853sc_ouring
scouting112612753sc_outing
scowing133812093sc__owing
scowling1458293sc_owling
scragging1435273scragging
scramming1634883scramming
scrapings14255173scr_apings
scrawling15195583scrawling
screaking16228243screaking
screaming14217833screaming
screeding1336323screeding
screening1247193screening
screwing14288233scr_ewing
scribing13238183scr_ibing
scrieving1534133scrieving
scripting1437473scripting
scriving14258763scr_iving
scroop10299783scroop___
scrooped1356403scroop_ed
scroops11288253scroop__s
scrootching1951893scrootching
scrounging1443353scrounging
scrubbing1633933scrubbing
scrumming1654023scrumming
scrupling1435193scrupling
scrying1338663scr__ying
sculping13298943sc_ulping
serotyping1643123serotyping
shmoozing2443613shmoozing
shooing112112913s_hoo_ing
shooling123012563s_hooling
shooting122812863s_hooting
shopping163611293s_hopping
shrimping1734063shrimping
shroffing1943313shroffing
shrouding1434753shrouding
siruping1136503sir_uping
sloping104114073s__loping
slopping133811423s_lopping
snooding102910433s_nooding
snooking133010583s_nooking
snooling93013473s_nooling
snooting92813203s_nooting
snoozing18319083s_noozing
soaping103616223s__oaping
sooting82820963s__ooting
sopping123917203s__opping
sorrowing1344873sorrowing
souping104215533s__ouping
spoofing14228363s_poofing
spooking15269803s_pooking
spooling113212563s_pooling
spooning112811443s_pooning
spooring113111463s_pooring
sprouting1236943sprouting
stomping13309763s_tomping
stooging102810043s_tooging
stooking132711143s_tooking
stooling93113133s_tooling
stoping103716623s__toping
stopping133611413s_topping
strapping1436993strapping
striping112612523str_iping
stripping1436493stripping
stroking132610943str_oking
strolling10238793strolling
strouding1136373strouding
strowing122310563str_owing
stroying122410593str_oying
swooning12278203s_wooning
swopping16377963s_wopping
syruping1434253syr_uping
tromping13319603_tromping
trouping11249503_trouping
unroofing1385703unroofing
unrooting1098833unrooting
uprooting1276903uprooting
varooming1545083varooming
vrooming14287353_vrooming
whooping17286633_whooping

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411726.53322752.3
3Display Results1721720.0762263.2
 (SQL Overall)1786911727.06225303.2
 
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.