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

110 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
scurrying1518383(None) 
currying14196491_currying
slurrying13203191slurrying
carrying14148372_carrying
curring103616842_curr_ing
flurrying16162802flurrying
hurrying15145532_hurrying
scarring112511512scarr_ing
scrying1338662sc__rying
serrying12167692s_errying
slurring9288832slurr_ing
spurring11339762spurr_ing
berrying14137373_berrying
blurring11277233blurr_ing
burring104016993_burr_ing
burying133413913_bu_rying
churring14298653churr_ing
crying123612283_c__rying
cullying14297503_cullying
curating11314293_curating
curbing123814023_cu_rbing
curding113515133_cu_rding
curdling12228893_curdling
curing94824783_cu_r_ing
curling104320183_cu_rling
cursing104217033_cu_rsing
curtsying1543813_curtsying
curving133912103_cu_rving
ferrying15146243_ferrying
furring114013143_furr_ing
harrying15157643_harrying
herrying15147023_herrying
hurraying1654323_hurraying
incurring1236873incurr_ing
jurying18337763_ju_rying
marrying14157223_marrying
miscarrying1942723miscarrying
occurring1443693occurr_ing
parrying14168133_parrying
purring104515823_purr_ing
quarrying2273733quarrying
querying2135243_querying
recarrying1643653recarrying
recurring1237953recurr_ing
salarying1336073salarying
scarfing14309713sc_arfing
scarifying1945013scarifying
scaring103421973sc_ar_ing
scarphing1735243scarphing
scarping133312463sc_arping
scarting113415263sc_arting
scorching1735633scorching
scorifying1944473scorifying
scoring103117213sc_or_ing
scorning1169133sc_orning
scourging1334573scourging
scouring112810853scour_ing
scraping133310863sc_raping
screwing14288233sc_rewing
scribing13238183sc_ribing
scriving14258763sc_riving
scrubbing1633933scrubbing
scrumming1654023scrumming
scrupling1435193scrupling
scubaing1335733scu_baing
scudding1335673scu_dding
scuffing17287113scu_ffing
scuffling1843613scuffling
sculking15307913scu_lking
sculling112910993scu_lling
sculping13298943scu_lping
sculpting1435003sculpting
scumbling1634423scumbling
scumming15256793scu_mming
scurried11267053scurr_ied
scurries102911483scurr_ies
scurril945113scurr_i_l
scurrile1055073scurr_ile
scurry11419593scurry___
scutching1735223scutching
scuttling1234243scuttling
securing11310413secu_r_ing
shirring122910443shirr_ing
skirring13297143skirr_ing
slurping11278123slu_rping
sourcing1158353sou_rcing
souring83219063sou_r_ing
sparring113112223sparr_ing
spraying14299883s_praying
spurning11258663spu_rning
spurting113111633spu_rting
squaring18158633squar_ing
squiring18177563squir_ing
squirming2143223squirming
squirting1934793squirting
starring92312953starr_ing
stirring9299653stirr_ing
storying12249673s_torying
straying122912693s_traying
stroying122410593s_troying
studying1335553stu_dying
subring104116263s_ubr_ing
sullying12328513s_ullying
surfing112914483s_u_rfing
surging93115433s_u_rging
surveying1644963s_urveying
tarrying12146723_tarrying
wherrying1952993wherrying
whirrying1962733whirrying
worrying1534703_worrying

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411107.61019532.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911108.10922036.1
 
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.