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

167 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
revolver1428771(None) 
evolver13275801_evolver
resolver11339791resolver
revolter11279361revolter
revolve13328371revolve_
revolved15328101revolved
revolvers15286111revolvers
revolves14278621revolves
devolve14316062devolve_
devolved16325512devolved
devolves15286262devolves
evolve12306502_evolve_
evolved14305582_evolved
evolvers14264772_evolvers
evolves13286742_evolves
involver1444662involver
recover124312622reco_ver
remover124612272remo_ver
reroller8258752reroller
resilver11337502resilver
resolder9259232resolder
resolve103910982resolve_
resolved12349342resolved
resolvers12297832resolvers
resolves113010782resolves
reveler104116342revel_er
reveller112912192reveller
reviler104314972revil_er
reviver134411372rev_iver
revoker14419192revo_ker
revolted12319862revolted
revolters12297482revolters
absolver1343693absolver
beholder1435053beholder
beveler124010693bevel_er
beveller13387693beveller
coevolve1642963coevolve_
coevolved1842453coevolved
coevolves1743213coevolves
delver104913493de__lver
desilver12286503desilver
devourer1235063devourer
devouter1235513devouter
elver85216243_e__lver
eviler94811893_evil_er
eviller1056673_eviller
evoker13467913_evo_ker
frivoler1443933frivol_er
frivoller1542433frivoller
involve1345093involve_
involved1534343involved
involvers1544033involvers
involves1444973involves
leveler10399903level_er
leveller11317603leveller
presolve1347073presolve_
presolved1545273presolved
presolves1456533presolves
raveler104212463ravel_er
raveller11339263raveller
realer63528593re_al_er
realter73716313re_alter
reaver94524733re__aver
recaller1039323recaller
receiver1337413receiver
recoiler103210493recoiler
recolor978693recol_or
reconfer1337673reconfer
reconvert1449473reconvert
reconvey1655603reconvey
recorder11249633recorder
recovers133511123reco_vers
recovery16366213reco_very
redeliver1344363redeliver
reeler63822573re_el_er
refilter1137153refilter
reflower14126843reflower
refolded1337063refolded
reformer13217953reformer
regaler83814623regal_er
reinvolve1542763reinvolve_
reinvolved1752563reinvolved
reinvolves1642773reinvolves
reiver95318293re__iver
rejoicer17315343rejoicer
relier65826183re__lier
reliever11448683reliever
reloader937913reloader
remolded1237403remolded
remoter94815973remo_ter
remove116115573remo_ve_
removed134611313remo_ved
removers13449223remo_vers
removes124514713remo_ves
reoffer1335013re_offer
reorder8239483re_order
repeller103010403repeller
replier94214973re_plier
repolled11359623repolled
reporter10411423reporter
reposer93715333repo_ser
repower12329883repo_wer
reprover13229203reprover
repulser1035803repulser
rerolled93010063rerolled
rerollers9207123rerollers
reseller83412253reseller
reserver11119633reserver
resilvers12306503resilvers
resolders10258013resolders
resole64624183resol_e_
resoled84119283resol_ed
resoles73823653resol_es
resoluter966183resoluter
resolvent1246583resolvent
resorter8312183resorter
retorter8410733retorter
revalue1038153revalue_
revalued1237023revalued
revalues1137883revalues
revamper1533533revamper
revealer113110073revealer
reveled113917753revel_ed
revelers113414133revel_ers
revelled123712743revelled
revellers12319513revellers
revenger1237303revenger
revenuer1136893revenuer
reverer103815833rev_erer
reverser113010483reverser
reverter114812873reverter
reviewer1434133reviewer
revile94921613revil_e_
reviled114417923revil_ed
revilers114011693revil_ers
reviles104421353revil_es
reviser104114663rev_iser
revive124914823rev_ive_
revived144211653rev_ived
revivers14389633rev_ivers
revives134715543rev_ives
revoice12319183revoice_
revoiced14317873revoiced
revoices13278993revoices
revoke135216243revo_ke_
revoked154410523revo_ked
revokers15366753revo_kers
revokes144212503revo_kes
revolt9316223revol__t
revolts1038893revol_ts
revolute1176793revolute
revolving1635843revolving
revote94917453revo_te_
revoted114314153revo_ted
revotes104716393revo_tes
revulsed1235443revulsed
revved13469723rev__ved
rewove126420083rewo_ve_
rewoven13557933rewo_ven
rolfer94412273r__olfer
roller63919793r__oller
rollover1144453rollover
rover85527373r__o_ver
runover1034663runo_ver
solver94016703__solver
unevolved1643083unevolved
wolver12419713__wolver

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621677.48319532.5
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.96922423.3
 
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.