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

138 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
resolvers1229783(None) 
resilvers12306501resilvers
resolders10258011resolders
resolver11339791resolver_
resolves113010781resolve_s
revolvers15286111revolvers
absolvers1443132absolvers
desilvers13306082desilvers
evolvers14264772_evolvers
presolves1456532presolve_s
recovers133511122reco_vers
removers13449222remo_vers
rerollers9207122rerollers
resellers9299902resellers
reservers12138102reservers
resilver11337502resilver_
resolder9259232resolder_
resoles73823652resol_e_s
resolve103910982resolve__
resolved12349342resolve_d
resolvent1246582resolvent
resolvents1344342resolvents
resorters939692resorters
revolters12297482revolters
revolver14287712revolver_
revolves14278622revolve_s
solvers104414252__solvers
absolver1343693absolver_
absolves1344413absolve_s
beholders1544933beholders
beshivers1743713beshivers
delvers113411993de__lvers
desalters1037673desalters
deservers13107293deservers
desilver12286503desilver_
desolaters1146043desolaters
devolves15286263devolve_s
dissolvers1444643dissolvers
elvers93814983_e__lvers
estovers1136453_estovers
evolver13275803_evolver_
evolves13286743_evolve_s
gasoliers1044203gasoliers
involvers1544033involvers
nestlers8359223nestl_ers
preservers15115693preservers
presolve1347073presolve__
presolved1545273presolve_d
realters83614043re_alters
reasoners947113reaso_ners
reavers108320743re__avers
recallers1137103recallers
receivers1436363receivers
recoilers11318153recoilers
recolors1078813recol_ors
reconfers1437213reconfers
reconvert1449473reconvert
reconverts1545723reconverts
reconveys1743533reconveys
recorders12187953recorders
recover124312623reco_ver_
recovery16366213reco_very
redelivers1443553redelivers
reelers73520273re_el_ers
refilters1236103refilters
reflowers15125983reflowers
reformers14246403reformers
regalers94311133regal_ers
reivers105117083re__ivers
rejoicers18324243rejoicers
reliers75519213re__liers
relievers12387063relievers
reloaders1036423reloaders
remover124612273remo_ver_
removes124514713remo_ve_s
reoffers1434693re_offers
reorders9198833re_orders
repellers11278873repellers
repliers103710163re_pliers
reporters1139173reporters
reposers102911603repo_sers
repowers13288533repo_wers
reprovers14217773reprovers
repulsers1144713repulsers
reroller8258753reroller_
resales74724903resal_e_s
rescuers1037363res_cuers
reseller83412223reseller_
reserver11119633reserver_
reserves111011983reserve_s
resetters9129463resetters
reshapers1435493reshapers
reshaves1438733reshave_s
reshowers15145473reshowers
residers93311883res_iders
resigners1036863resigners
resiles74026543resil_e_s
resilvered1442993resilvered
resisters9310453resisters
resoftens1243713resoftens
resojets1535343reso_jets
resoldered1243963resoldered
resole64624183resol_e__
resoled84119283resol_e_d
resoluter966183resoluter_
resolutes968193resolutes
resolving1337743resolving
resorter8312183resorter_
responders1345773responders
resters74130403res__ters
restless82713163restl_ess
restorers95110113restorers
resumers1038083res_umers
resurveys1542683resurveys
retorters938773retorters
revelers113414133revel_ers
revellers12319503revellers
revers94529633re___vers
revilers114011693revil_ers
revivers14389633re_vivers
revokers15366753revo_kers
revolter11279363revolter_
revolve13328373revolve__
revolved15328103revolve_d
rolfers104011813r__olfers
rollers73117473r__ollers
rollovers1244093rollovers
rovers95423523r__o_vers
runovers1134473runo_vers
rustlers8339853rustl_ers
salvers103916003__salvers
silvers104714043__silvers
solders83517773__solders
solver94016703__solver_
solves95018223__solve_s
unsolders1064693unsolders
wolvers13349313__wolvers
wrestlers12306103wrestl_ers

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.423422437.4
2DLD Change Limit1486411386.64022385.7
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.12625075.9
 
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.