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

104 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
realgars93453(None) 
realgar834871realgar_
realters83614042realters
realtors82811682realtors
agars66120643__a_gars
alegars838933__alegars
algas65624933__alga_s
algors7312553__algors
altars64518153__altars
amalgams1343203amalgams
beggars11378223be_ggars
belgas9311713be_lga_s
calcars11312653_calcars
cellars93713693ce_llars
dealers84118613deal_ers
desugars1043373desugars
eagers74523683_ea_gers
eggars8398973_e_ggars
hangars114313493_hangars
headgears1443153headgears
healers104319463heal_ers
malars85020683_mal_ars
medlars10259443medl_ars
pedlars103210213pedl_ars
prealters1147773prealters
preclears1344373preclears
radars71314673r_a_dars
ragas65326063r_a_ga_s
raglans82410133r_aglans
railcars1045313railcars
rangers83621043r_angers
reachers133515723reachers
reactors103212293reactors
readers83823773rea_ders
reagins84215643rea_gins
realer63528593real_er_
reales64934123real__es
realia6314593realia__
realigns936253realigns
realisers9248323realisers
realises82420183realises
realisms102212163realisms
realists83014843realists
realizers18237933realizers
realizes173116843realizes
reallots837993reallots
realms84913493real__ms
realness8410443realness
reals55038653real___s
realter73716313realter_
realties8514853realties
realtor73611353realtor_
reamers94221083rea_mers
reapers93520453rea_pers
reappears1342853reappears
rearers74323563rea_rers
rearguard1142393rearguard
reargues936713reargues
rears54739653re___ars
rearward1245783rearward
rearwards1344803rearwards
reatas64021013rea_ta_s
reavers108320743rea_vers
rebars84019833re__bars
recallers1137103recallers
reclads1049993recl_ads
recleans1037513recleans
redears82814453re_dears
reelers73520273reel_ers
reflags1156953refl_ags
refloats1156913refloats
regalers94311133regal_ers
regard85215773re__gard
regards94112563re__gards
regears83012463re_gears
reggaes948883re_ggaes
regulars936253regulars
rehears103312773re_hears
relaters83218153relaters
relators83316133relators
relaxers15298263relaxers
relays94316753re_l_ays
relearn747973re_learn
relearns836303re_learns
reliers75519213re_liers
reloads8911313re_loads
reloans7313133re_loans
renegers9248793renegers
replans92814943repl_ans
replays12399763repl_ays
repleads11357213repleads
repliers103710163repliers
retears72814923re_tears
rewears102911043re_wears
saggars93610683_saggars
sangars83116253_sangars
scalars93711903scal_ars
sealers74323553seal_ers
seggars9377783se_ggars
talars66021683_tal_ars
teargas837013tearga_s
vealers103214293veal_ers
velars93913723ve_l_ars
vulgars11306533_vulgars

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.796224486.2
2DLD Change Limit1461621047.95318378.2
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.79520317.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.