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

149 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
restorers9511011(None) 
restorer84813721restorer_
restores85222991restore_s
bestowers14135322bestowers
estovers1136452_estovers
gesturers1044282gesturers
pesterers112510452pesterers
prestores114716082prestore_s
rescores105415692rescore_s
reshowers15145472reshowers
resorters939692res_orters
resters74130402rest__ers
restokes125213042restoke_s
restorals978072restorals
restore75822982restore__
restored96417192restore_d
restress82511772rest_ress
retirers84311532re_tirers
retorters938772re_torters
storers75018682__storers
bestower13126203bestower_
bestrews1335603best_rews
cestodes1138203cestode_s
customers1344783customers
deplorers1245463deplorers
desirers939263des_irers
destriers1038143destriers
destroyers1443643destroyers
distorters1147163distorters
enterers82214153_enterers
esters64627733_est__ers
extorters1645763_extorters
festers104121393fest__ers
fetterers12267043fetterers
fosterers12238023fosterers
frescoers1454563fresco_ers
gesturer935983gesturer_
gestures9310013gesture_s
jesters144118193jest__ers
kestrels1235813kest_rels
lecturers11124233lecturers
leftovers1542783leftovers
letterers9228113letterers
nesters74422793nest__ers
nestlers8359223nest_lers
nestors73614973nesto__rs
oysterers1245573oysterers
pasturers1136393pasturers
pesterer102412703pesterer_
pesters93827093pest__ers
pewterers14216043pewterers
posturers1137053posturers
prescores133912173prescore_s
presters103419003prest__ers
prestore104217353prestore__
prestored125111673prestore_d
prestress1138133prest_ress
rasters74629023rast__ers
rearers74323563re__arers
reasoners947113reasoners
rebores95319163re_bore_s
reckoners1545113reckoners
recorders12187953re_corders
recovers133511123re_covers
rectories11314643rectories
rectors93520523recto__rs
referrers12125373referrers
reflowers15125983reflowers
reformers14246403re_formers
removers13449223re_movers
renderers10208093renderers
renters74224813rent__ers
rentiers83311763rent_iers
reorders9198833re__orders
repairers1135283repairers
reporters1139173re_porters
reposers102911603re_posers
repowers13288533re_powers
reprovers14217773reprovers
requirers18165003requirers
rescore95616203rescore__
rescored114513103rescore_d
rescuers1037363res_cuers
resellers9299903resellers
reservers12138103reservers
resetters9129463resetters
reshapers1435493reshapers
reshoes102316033resho_e_s
reshower14107063reshower_
residers93311883res_iders
resigners1036863resigners
resilvers12306503resilvers
resisters9310453resisters
resojets1535343res_ojets
resolders10258013resolders
resoles73823653res_ole_s
resolvers12297833resolvers
resorbs95010523res_or_bs
resorter8312183res_orter_
resorts74817193res_or_ts
respires10311903respire_s
responders1345773responders
restages92815773restage_s
restarts8310873restar_ts
restates83423433restate_s
rester63832433rest__er_
restless82713163rest_less
restocks1437503resto_cks
restoke116113903restoke__
restoked135710533restoke_d
restoral8810983restor_al
restoring10314613restoring
restrooms1146033restrooms
restyles1139193restyle_s
resumers1038083res_umers
retakers123511133re_takers
retarders10227573re_tarders
retirees84611653re_tirees
retirer74715013re_tirer_
retires74726213re_tire_s
retore67630773re_tore__
retorter8410733re_torter_
retorts76016513re_tor_ts
returners9376553re_turners
reutters8138573reut_ters
reverers113113153re_verers
revokers15366753re_vokers
roisterers1045113roisterers
rosters73727543rost__ers
rustlers8339853rust_lers
scorers94115323__scorers
snorers74313803__snorers
starers74522313__starers
stokers114515183__stokers
stoners74817953__stoners
stopers94217373__stopers
storer64721673__storer_
stores65533663__store_s
storeys10559653__storeys
stovers103713733__stovers
testers74124543test__ers
venturers1245523venturers
vestures11311043vesture_s
vetoers10359473ve_to_ers
westerners1344463westerners
westers105221963west__ers
wresters112711733wrest__ers
wrestlers12306103wrest_lers
zesters163517293zest__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.420425454.8
2DLD Change Limit1486411496.95321378.0
3Display Results1491490.0801862.5
 (SQL Overall)1786911497.45323975.7
 
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.