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

275 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
revolting133963(None) 
revolving1635841revolving
revoting12312031revo_ting
devolving1733982devolving
devoting1338822devo_ting
evolving1533432_evolving
rebooting12139022rebooting
recoating121317462recoating
refolding1437452refolding
remelting12311702remelting
remolding1338162remolding
repolling122110202repolling
reporting12513902reporting
repotting12511122repotting
rerolling102210372rerolling
rerouting10311872rerouting
resoling92916302resol_ing
resolving1337742resolving
resorting10614612resorting
resulting10311082resulting
retorting10613272retorting
revaluing1337302revaluing
reveling123117082revel_ing
revelling132412552revelling
reverting132315132reverting
revesting132814122revesting
revetting132912632revetting
reviling122917212revil_ing
reviolating1556262reviolating
revoicing15117712revoicing
revoking1637802revo_king
revoltingly1852812revoltingly
beholding1634233beholding
belting104119133be__lting
besotting12256873besotting
beveling143011033bevel_ing
bevelling15227453bevelling
bevomiting1843103bevomiting
bolting104416763__bolting
breveting1536263brev_eting
brevetting1644333brevetting
cavorting1536063cavorting
coevolving1942353coevolving
decocting1538123decocting
dehorting1447213dehorting
demoting12311423demo_ting
denoting10311753deno_ting
deporting1369593deporting
desalting1138843desalting
desolating1239463desolating
devaluing1434833devaluing
develing133212733devel_ing
devesting14249903devesting
deviating14311083deviating
deviling1311812853devil_ing
devilling1436703devilling
devoicing16145223devoicing
devouring1435953devouring
emoting10313563_emo_ting
everting122213133_everting
evicting1437483_evicting
eviting11511373_ev_iting
evoking1536413_evo_king
evulsing1234733_evulsing
exalting1638033_exalting
exulting1637643_exulting
felting113515213fe__lting
frivoling1644493frivol_ing
frivolling1742763frivolling
gavotting1443193gavotting
involuting1444613involuting
involving1644363involving
jolting153410913__jolting
levanting1345523levanting
leveling122910433level_ing
levelling13206973levelling
melting103317753me__lting
molting103517173__molting
pelting102917273pe__lting
pivoting1436183pivo_ting
premolding1644673premolding
presolving1644363presolving
presorting1339983presorting
prevaluing1644273prevaluing
preventing161210263preventing
ragouting1134893ragouting
raveling123414373ravel_ing
ravelling13269243ravelling
reacting113317893re_acting
readopting1465513readopting
reavowing1634863reavo_wing
rebaiting12311643rebaiting
rebating112418343re_bating
rebelling122111163rebelling
rebilling12228833rebilling
rebodying1635003rebodying
reboiling12149823reboiling
rebooking16146393rebooking
reboring11312783rebo_ring
rebottling1343733rebottling
rebutting1237523rebutting
recalling122211903recalling
recanting122414823recanting
recasting122414233recasting
reciting113118073re_citing
reclothing1644973reclothing
recoaling121312453recoaling
recocking18138373recocking
recoding122213853reco_ding
recoiling121412413recoiling
recoining121313803recoining
recoloring1367583recoloring
recombing1637323recombing
reconning121410793reconning
recooking16148543recooking
recopying1737113recopying
recording131311623recording
recorking16149643recorking
recounting1339193recounting
recouping1438363recouping
recrating121318793recrating
recutting1239483recutting
redacting13612303redacting
redating102620173re_dating
reddling112911813reddl_ing
redocking17126783redocking
redoing93516733redo__ing
redonning11127643redonning
reediting11310953reediting
reedling102414273reedl_ing
reeling83126863re_el_ing
reesting93118273re_esting
reevoking1734223reevo_king
refalling132010423refalling
refecting152413353refecting
refelling132211313refelling
refiling123116533refil_ing
refilling13299333refilling
refilming15256463refilming
refitting132811123refitting
reflating132514713reflating
refloating14198323refloating
reflowing1636523reflowing
reflying15268173re_flying
reforging1437663reforging
reforming1538563reforming
refronting1437273refronting
refuting121911903re_futing
regaling10315363regal_ing
regelating1239953regelating
regilding1236123regilding
reglowing1436173reglowing
regluing1077033re_gluing
regorging1236823regorging
regrating111316213regrating
regulating12310063regulating
reheating132314913reheating
rehousing1337253rehousing
reinvolving1852403reinvolving
rejecting192211153rejecting
rejoicing19136943rejoicing
rejoining17149223rejoining
reknotting1564233reknotting
relating92725443re_lating
relenting102716773relenting
reletting102713943reletting
relisting102414353relisting
reloading1189883reloading
reloaning10710483reloaning
relocating13310873relocating
relocking16137683relocking
relooking14167143relooking
relucting1239773relucting
relying112914613re__lying
remating112322423re_mating
remeeting12311433remeeting
reminting122315103reminting
remitting122412623remitting
remounting1346673remounting
removing1439083remo_ving
renesting102514703renesting
renovating1447423renovating
renowning1336083renowning
renting84026853re__nting
reoiling93217213re_oiling
repasting122312843repasting
repeating122618983repeating
repelling122312753repelling
repenting122316553repenting
replating122217403replating
replotting1357043replotting
replowing1537413replowing
replying14269403re_plying
reposing111213803repo_sing
repositing13310493repositing
repouring12310073repouring
repulsing1237613repulsing
reputing112412603re_puting
requiting1939883requiting
rerenting102617663rerenting
reroofing1336863reroofing
resaluting1137393resaluting
reseating102421533reseating
resecting122816483resecting
reselling102213833reselling
resenting102619293resenting
resetting102816293resetting
reshooting1436223reshooting
resifting133512093resifting
resiling93520173resil_ing
resisting103215313resisting
resiting93521123re_siting
resitting103414873resitting
reslating102516993reslating
resmelting1337263resmelting
resoaking1439373resoaking
resodding1237203resodding
resonating11311263resonating
resorbing1269353resorbing
resowing123111523reso_wing
respiting121912863respiting
respotting1347113respotting
restating102319413restating
resting85031183re__sting
retasting102513413retasting
retelling102112493retelling
retesting102614603retesting
retiling93319483retil_ing
retinting102215253retinting
retitling1039773retitling
retooling1039093retooling
retting83425883re__tting
reuniting10310693reuniting
revaluating1545893revaluating
revamping1734633revamping
revealing132611883revealing
revenging1438083revenging
reverbing15248593reverbing
revering122918073rev_ering
reversing132611483reversing
reviewing1635513reviewing
revising122714403rev_ising
revisiting1446953revisiting
reviving152910503rev_iving
revolt9316223revolt___
revolted12319863revolt_ed
revolter11279363revolt_er
revolters12297483revolters
revolts1038893revolt__s
revolution13117563revolution
revolutions1497633revolutions
revving14379343rev__ving
rewelding1436913rewelding
rewetting132710443rewetting
rewording14158543rewording
reworking17136873reworking
rewriting13310413rewriting
rezoning18310453rezo_ning
rioting82716393r_io_ting
riposting1236063riposting
rivaling1239913rival_ing
rivalling1335963rivalling
riveting12139443riv_eting
rivetting13256413rivetting
rolfing113710653r__olfing
rolling83620413r__olling
roosting93411463r_oosting
rooting83522433r__ooting
rootling9269953r_ootling
rotting82919683r__otting
routing83821093r__outing
unbolting1236453unbolting
voling103918023__vol_ing
voting103916033__vo_ting
welting113615313we__lting

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 Limit1486412757.71619264.0
3Display Results2752750.1262182.5
 (SQL Overall)1786912758.29521542.0
 
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.