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

145 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
estraying133829(None) 
straying122912691_straying
betraying1537712betraying
destroying1564902destroying
essaying1235032es_saying
estating92614992est_ating
estranging1246022estranging
estreating11710362estreating
respraying1636092respraying
spraying14299882_spraying
staying114017322_st_aying
strafing122111192_strafing
strawing122411622_strawing
stroying122410592_stroying
affraying1943103affraying
arraying1238753_arraying
assaying1236003as_saying
astonying1345233astonying
besteading1446033besteading
bestrewing1643773bestrewing
bestriding1446003bestriding
bestrowing1644373bestrowing
bewraying1834873bewraying
braying134416313__braying
castrating1349773castrating
defraying1735853defraying
descrying1635103descr_ying
draying123813843__draying
embaying1635263e_mbaying
embracing1645443embracing
enframing1546113enframing
engraving1446013engraving
enraging1049573e_nraging
entrain7313073entra_in_
entraining1147643entraining
entrains8312963entra_ins
entrancing1346783entrancing
entrapping1544873entrapping
entreating11811553entreating
erasing8317963e__rasing
escaping1347063es_caping
escarping1435203escarping
escrowing1544813escrowing
espying1336193es__pying
esteeming1244703esteeming
esterifying1873693esterifying
estimating1348883estimating
estivating1447633estivating
estopping1434793estopping
estradiol1043683estradiol
estragon944793estragon_
estragons1044653estragons
estrange9488893estra__nge
estray95713333estray___
estrayed1236393estray_ed
estrays10529403estray__s
estrin6315923estr__in_
estrins7315853estr__ins
estuarine944983estuarine
extracting2047223extracting
extruding1844333extruding
foraying1537433_foraying
fraying143413433__fraying
gestating11229983gest_ating
graying124115883__graying
hooraying1644783hooraying
hurraying1654323hurraying
lustrating1147783lustrating
mistracing1569603mistracing
nitrating10312673nitrating
outlaying1338543outlaying
outpraying1646523outpraying
outracing12912163outracing
outraging111010883outraging
outrating10916403outrating
outraving13910133outraving
outsaying1338703outsaying
portraying1645163portraying
praying133717323__praying
raying105027193___raying
resaying122512453res__aying
restaging112410853rest_aging
restarting11310663restarting
restating102319413rest_ating
restrain8311703restra_in_
restraining1247533restraining
restrains9311623restra_ins
restraint9412753restra_int
restriking1548043restriking
restring91518783restr__ing
restriving1448133restriving
restudying1543423restudying
retracing12313293retracing
retrying122410453retr_ying
saying104325543_s__aying
scraping133310863_scraping
scrying1338663_scr_ying
serrating10513213serrating
serrying12167703_serrying
slaying113316843_s_laying
spaying133014623_s_paying
splaying14219303_splaying
staging93818373_st_aging
staking123919803_st_aking
staling83925423_st_aling
staning83922243_st_aning
staring84527053_st_aring
starling93017123_starling
starring92312953_starring
starting93116173_starting
starving122510173_starving
stating83725163_st_ating
staving113915703_st_aving
steading103613593_steading
steadying14154503_steadying
stealing93416603_stealing
steaming114013213_steaming
stimying1437503_stimying
storying12249673_storying
strain64919573_stra_in_
straining10410563_straining
strains74218153_stra_ins
stranding1149653_stranding
strang75718313_stra__ng
strapping1436993_strapping
streaking142010323_streaking
streaming12239653_streaming
strewing12289853_strewing
striating10914193_striating
striding102713603_striding
striking133012233_striking
string75327563_str__ing
striping112612523_striping
striving122611393_striving
stroking132610943_stroking
strowing122310563_strowing
studying1335553_studying
stying105414573_st__ying
stymying1733963_stymying
swaying143610643_s_waying
testifying1745403testifying
titrating10310113titrating
tracing103720153__tracing
trading93517973__trading
trying104214073__tr_ying

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.466383457.1
2DLD Change Limit1486411457.31320325.6
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.84222786.4
 
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.