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 “rehearse” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
rehearse1129665(None) 
rehears103312771rehears_
rehearsed13305911rehearsed
rehearser12265021rehearser
rehearses12286841rehearses
hearse94114272__hearse
redears82814452redears_
regears83012462regears_
rehear93713222rehear__
reheard11309022rehear_d
rehearsal1242342rehearsal
rehearsers13273862rehearsers
reheats104513522reheats_
release7312762relea_se
retears72814922retears_
reverse103913742reve_rse
rewears102911032rewears_
beheads1338523beheads_
decease1049523decea_se
hears86737373__hears_
hearsed113811403__hearsed
hearses104414533__hearses
hoarse94411323__hoarse
preheats1339413preheats_
rears54739653r__ears_
rebars84019823re_bars_
recharge1476613recharge
recheats1339193recheats_
recourse1038383recourse
redear73515173redear__
redheads1336173redheads_
redhorse1245463redhorse
redware1139353redwar_e
redwares1239053redwares
reearn6612143re_ear_n
reearned948883re_earned
reearns749103re_earns
referee101615753refe_ree
refers93921083refe_rs_
regear73512743regear__
regeared1039433regeared
rehabs1139023reh_abs_
reharden1276303reh_arden
rehash1237433reh_a_sh
rehearing132211763rehearing
rehearsals1351753rehearsals
rehearsing1444343rehearsing
reheat94423943rehea__t
reheated122415003reheated
reheater113413033reheater
reheaters122010263reheaters_
reheels10298253reheels_
rehems113410983rehe_ms_
rehire95415863reh_ir_e
rehires105016113reh_ires
rehouse10311773reh_ouse
relapse947703re_lapse
relearn747973relear_n
relearned1035633relearned
relearns836303relearns
relearnt849213relearnt
released9310243relea_sed
releaser839503relea_ser
releases8313343relea_ses
remerge10148923reme_rge
remorse9311713re_morse
rennase738713renna_se
repeals94014523repeals_
repeats94316053repeats_
rephrase1346733rephra_se
reraise7316313re_raise
rereads81512293rereads_
reseals73917663reseals_
research1344553research
reseats74319583reseats_
reseaus74012153reseaus_
reserve101011203rese_rve
reteams9339563reteams_
retear63115483retear__
retrorse837623retrorse
reveals103812723reveals_
revere94621253reve_r_e
reveres103621343reve_res
reverie103615163reve_rie
revers94529633reve_rs_
reversed122711613reve_rsed
reverser113010483reve_rser
reverses112513513reve_rses
reverso10367693reve_rso
rewear93011993rewear__
reweave1336773rewea_ve
reweaves1436603reweaves
rheas84816953r_hea_s_
shears93820903_shears_
unrehearsed1552203unrehearsed

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.250714764.0
2DLD Change Limit146162958.15617920.8
3Display Results95950.0462065.2
 (SQL Overall)178691958.45221141.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.