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

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

49 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
prerequires225149(None) 
prerequire2151841prerequire_
prerequired2351361prerequired
prerequiring2451483prerequiring
prerequisites2461193prerequisites
reacquires2142993_reacquires
requires17168703___requires
enquires17276974__e_nquires
esquires17266214__e_squires
exequies2444154__exequi_es
perdures11289684p_er_du_res
peregrines1346514p_eregrines
periques1937664p_eriqu__es
perjures17268084p_er_ju_res
perjuries1846494p_er_juries
perspires1346664p_er_spires
praemunires1551254pr_aemunires
preassures1245274preassu_res
precures12312904p__recu_res
predefines1645434prede_fines
predestines1446994predestines
preemies12512194pre_e_mi_es
preexcites2144164pre_excites
prefectures1844304prefectures
prefigures1643904prefigu_res
prefires134313284p__re_fires
preguides1344864p__reguides
prelatures1245734prelatu_res
prematures1447064prematu_res
premeasures1552824premeasures
prerecords1542784prere_cords
prereleases1353164prereleases
prerequisite2361374prerequisite
prereturn1143394preretu_r_n
prereview1742994prere_vi_ew
pressures1149064pre_ssu_res
preterites12411804prete_rites
preventives1945724preventives
prewires133811014p__re_wires
procedures1543374procedu_res
reacquire2043054_reacquire_
reacquired2242624_reacquired
reequips1942364_re_equi_ps
require16148654___require_
required18156834___required
requirer17156114___requirer
requirers18165004___requirers
requites171511764___requites
resecures1146734_resecu_res

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit148819498.58017344.9
3Display Results49490.0133769.2
 (SQL Overall)178691498.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.