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

199 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
reshaving165727(None) 
reshaping1557741reshaping
behaving1735452be_having
beshaming1735672beshaming
preshaping1845422preshaping
reaving113820532re__aving
repaving142810742re_paving
resawing122311432res_awing
resaying122512452res_aying
rescaling122212012rescaling
resealing102115672resealing
reseating102421532reseating
reserving131110642reserving
reshaven1435192reshaven_
reshining13310742reshining
reshoeing1336592reshoeing
reshowing1646632reshowing
reslating102516992reslating
resoaking1439362resoaking
resolving1337742resolving
respacing1438892respacing
respading1338802respading
restaging112410852restaging
restating102319412restating
reweaving16227072reweaving
shaving143414332__shaving
behoving1734913be_hoving
bereaving1537563bereaving
deaving123814753de__aving
deleaving1436263deleaving
depraving1635963depraving
deserving1497903deserving
dissaving1436953dissaving
enslaving1345383enslaving
escaping1347063_escaping
essaying1235033_essaying
estating92614993_estating
exhaling1936293_exhaling
freshening1744773freshening
freshing152611023fresh__ing
gestating11229983gestating
having134220373___having
heaving144114763he__aving
heehawing1943183heehawing
leaving114216853le__aving
meshing134513813mesh__ing
messaging1345333messaging
prepaving1787233pre_paving
presaging1339393pres_aging
preserving1637363preserving
preshowing1944473preshowing
presoaking1736243presoaking
presolving1644363presolving
pshawing1733523_pshawing
raving105128853r___aving
reading93327213re__ading
reaming103924013re__aming
reaping103621213re__aping
rearing83128783re__aring
reawaking17216063reawaking
rebating112418343re_bating
recaning111416693re_caning
receiving1538993receiving
rechanging1746043rechanging
recharging1745293recharging
recharting1637213recharting
rechewing1836493rechewing
recoaling121312453recoaling
recoating121317463recoating
recrating121318783recrating
recurving1536773recurving
redating102620173re_dating
redialing11311843redialing
redrawing1437203redrawing
redriving1437603redriving
reenslaving1552473reenslaving
reeving113717663re__eving
refacing142512813re_facing
reflating132514713reflating
reframing1538613reframing
regaling10315363re_galing
regearing112211413regearing
regiving13269713re_giving
reglazing2046553reglazing
regrading121210193regrading
regrating111316203regrating
rehabbing1733653re_habbing
rehang1039823re_ha__ng
rehanging1437563re_hanging
rehashing1647113re_hashing
rehearing132211763rehearing
reheating132314913reheating
rehiring122911883re_hiring
reimaging1336493reimaging
reiving113316843re__iving
relacing112516043re_lacing
relating92725443re_lating
relaxing162612633re_laxing
relaying122515153re_laying
releasing10411013releasing
relieving1336693relieving
reliving122713343re_living
reloading1189883reloading
reloaning10710483reloaning
remaking152613293re_making
remating112322403re_mating
removing1439083re_moving
renaming11313693re_naming
repaying142712393re_paying
repealing122513543repealing
repeating122618983repeating
rephrasing1645643rephrasing
replacing142210163replacing
replating122217393replating
replaying15259603replaying
reproving1538413reproving
rereading111212703rereading
resailing103314253resailing
rescoring12310603rescoring
rescuing1139623res_cuing
resecting122816483resecting
reseeding112410493reseeding
reseeing92412623res_eeing
reseeking14208493reseeking
reseizing19311233reseizing
reselling102213833reselling
resending112313363resending
resenting102619293resenting
resetting102816293resetting
resewing122712263res_ewing
reshave1338603reshav__e
reshaved1536873reshav_ed
reshaves1438733reshav_es
reshine102816943resh__ine
reshipping1843793reshipping
reshooting1436223reshooting
residing103015473res_iding
resifting133512093resifting
resigning1139463resigning
resiling93520173res_iling
resinating11313733resinating
resining92919553res_ining
resisting103215303resisting
resiting93521123res_iting
resitting103414873resitting
resizing182714163res_izing
resodding1237203resodding
resoling92916303res_oling
resonating11311263resonating
resorbing1269353resorbing
resorting10614613resorting
resowing123111523res_owing
respeaking1736793respeaking
respiring12159903respiring
respiting121912863respiting
respraying1636093respraying
respring111614063res_pring
restabling1337653restabling
restacking1737183restacking
restaffing1744193restaffing
restamping1565213restamping
restarting11310663restarting
resting85031183res__ting
restoking1438193restoking
restoring10314603restoring
restring91518783res_tring
restriving1448123restriving
restyling1337923restyling
resulting10311083resulting
resuming11310083res_uming
resurging1138613resurging
retaking133114273re_taking
retaping113012553re_taping
retaxing162311333re_taxing
reteaming122110443reteaming
retearing102214253retearing
retracing12313283retracing
revealing132611883revealing
reviving152910503re_viving
revolving1635843revolving
revving14379343re__vving
rewaking162310973re_waking
rewaxing19248563re_waxing
rewearing132310703rewearing
rushing113817703rush__ing
sashaying1644593sashaying
saving104724513__s_aving
shading123115563__shading
shaking153317253__shaking
shaming133016743__shaming
shaping133116183__shaping
sharing113723243__sharing
shavings15356333__shavings
shawing143514883__shawing
sheaving154110253__sheaving
shoving142910633__shoving
slaving113514833__slaving
staving113915703__staving
weaving143211623we__aving

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.1701051123.5
2DLD Change Limit1486411998.36017780.0
3Display Results1991990.0802487.5
 (SQL Overall)1786911998.61020753.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.