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 “surveying” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
surveying164496(None) 
purveying1843571purveying
surveyings1741971surveyings
curveting1535352curveting
resurveying1842592resurveying
subvening1546032subvening
surviving1644162surviving
burdening1335543burdening
burying133413913bur__ying
conveying1838323conveying
currying14196493cur_rying
curtseying1641983curtseying
curtsying1543813curtsying
curvetting1643393curvetting
curving133912103curv__ing
greying124110893_gr_eying
hurraying1654323hurraying
hurrying15145533hur_rying
journeying2142413journeying
jurying18337763jur__ying
marveling1537103marveling
murdering1357133murdering
outvying1536063outv_ying
parleying1536113parleying
presurveying2151353presurveying
preying133114553_pr_eying
pureeing1137273pur_eeing
purifying1835853purifying
quavering2235953quavering
quivering2235873quivering
savvying1862723s_avvying
screeding1336323screeding
screening1247193screening
screwing14288233scr_ewing
scrieving1534133scrieving
scrying1338663scr__ying
scurrying15183833scur_rying
serrying12167703ser_rying
servicing1545343servicing
serving113014983serv__ing
severing122013853s_evering
shaveling1646843shaveling
shivering1637333shivering
shoveling1635553shoveling
shrewing15228093shr_ewing
shrieking1734583shrieking
shrieving1633973shrieving
shriveling1743253shriveling
silvering1337923silvering
skivvying2391603skivvying
slavering1338723slavering
slivering1338083slivering
slurrying13203193slur_rying
sniveling1336033sniveling
spraying14299883spr_aying
starveling1444263starveling
straying122912693str_aying
streeking14217453streeking
streeling10189483streeling
strewing12289853str_ewing
stroying122410593str_oying
subverting1666293subverting
subwaying1843873subwaying
suckering1638103suckering
sueding92613753su__eding
suffering1637293suffering
sullying12328513su_llying
summering1458753summering
sundering11312323sundering
supering11317683su_pering
supervening1755783supervening
supplying1774043supplying
surceasing1345073surceasing
surfacing1545643surfacing
surfeiting1445023surfeiting
surfing112914483sur__fing
surging93115433sur__ging
surmising1247683surmising
surnaming1245143surnaming
surtaxing1784143surtaxing
surveil1045093surve_i_l
surveilling1542813surveilling
surveils1144523surve_ils
survey124111673survey___
surveyed1544233survey_ed
surveyor1442263survey_or
surveyors1542293surveyors
surveys13357573survey__s
swiveling1634573swiveling
tourneying1442533tourneying

Search took 7 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.406440125.6
2DLD Change Limit148641906.26623721.8
3Display Results90900.0461956.5
 (SQL Overall)178691906.71826598.8
 
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.