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

123 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
rezeroes173714(None) 
rezeroed1835991rezeroed
rezeros1647451rezero_s
referees111310412referees
remerges111110202remerges
reserves111011982reserves
reveres103621342rever_es
reveries112518512reveries
reverses112513512reverses
rezero1578872rezero__
zeroes154314342__zeroes
breweries1447583breweries
celeries10316313celeries
demerges12129503demerges
deserves12109893deserves
deterges101510093deterges
emerges101310883_emerges
emeries91620023_emeries
emerods10137653_emerods
feverous1446513feverous
gazeboes2043393gazeboes
generous939773generous
heroes94923823__heroes
heteros10312683hetero_s
heteroses12410783heteroses
mezereon1942233mezereon
mezereons2041933mezereons
peeries93623023pe_eries
preserves14109073preserves
razees154314763raze__es
razers154919613razer__s
rebores95319163rebor_es
reburies10311143reburies
recedes102816063rece_des
receives1339743receives
recesses10312323recesses
recross989833re_cross
recurves1337403recurves
redefies12710163redefies
redenies9615713redenies
redeyes112910973rede_yes
redoes74623773r__edoes
redries83721713re_dries
reechoes1338413reechoes
reemerges1255173reemerges
reeves94721493re_e_ves
reevokes15375993re_evokes
refences13311843refences
referee101615753refer_ee
refereed12149693refereed
referred1297833referred
referrer11136053referrer
referrers12125373referrers
refers93921083refer__s
refires104820313refir_es
reforges12249333reforges
refries104419733re_fries
regorges10238413regorges
regrows11269153re_grows
rehearses12286843rehearses
rehires105016113rehir_es
releases8313343releases
releves103914973rele_ves
remedies11310553remedies
remerge10148923remerge_
remerged12149173remerged
remorses10311993remorses
reneges82513593rene_ges
reperked15177793reperked
reperks13298093reper_ks
reprobes121910293re_probes
repros84216003re_pro_s
reproves132011473re_proves
reredos838633reredo_s
reredoses1045773reredoses
rerose63320843r__erose
rescores105415693rescores
resees63827483rese__es
reseizes1759853reseizes
reserve101011203reserve_
reserved121010583reserved
reserver11119633reserver
reservers12138103reservers
reshoes102316033re_shoes
restores85222993restores
resurges9310123resurges
retenes76324623rete_nes
retirees84611653retirees
retires74726213retir_es
retries74129073re_tries
retros63820193re_tro_s
revelries1246923revelries
revelrous1243893revelrous
revenges1238983revenges
revenues1138663revenues
reverbed14269223reverbed
reverbs12368863rever_bs
revere94621253rever_e_
revered112819333rever_ed
reverer103815833rever_er
reverers113113153reverers
reverie103615163reverie_
revers94529633rever__s
reverse103913743reverse_
reversed122711613reversed
reverser113010483reverser
reversers12298483reversers
reversos11266713reversos
reverted122714713reverted
reverter114812873reverter
reverters122710433reverters
reverts104715043rever_ts
reweaves1436603reweaves
rewires104717113rewir_es
rezeroing1935933rezeroing
rezones163213943rez_ones
roperies10315763roperies
roseries8317313roseries
ruderies9311333ruderies
veeries102916893ve_eries
veneries112815033veneries
zeroed16409413__zeroed
zeros144918113__zero_s

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 Filter1786911461620.890200776.4
2DLD Change Limit1461621237.73318901.1
3Display Results1231230.0502460.0
 (SQL Overall)1786911238.67320603.1
 
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.