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

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

39 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
prerequisites246119(None) 
prerequisite2361371prerequisite_
perquisites2252812p_er_quisites
corequisites2351443_corequisites
perquisite2153413p_er_quisite_
prerequires2251493prerequ__ires
requisites1964503___requisites
corequisite2251754_corequisite_
exquisites2652764__e_xquisites
preregister1452994prere_gis_ter
preregisters1552234prere_gis_ters
prerequire2151844prerequ__ire_
prerequired2351364prerequ__ired
prerequiring2451484prerequiri_ng
requisite1865424___requisite_
cerusites1146525_cer__u_sites
cerussites1243185_cer__ussites
exquisite2543435__e_xquisite_
marquisates2252225_mar_quisates
peregrinates1553355p_eregrinates
perfusates1543995p_er_fu_sates
perpetuities1653475perpetuiti_es
pertussises1352125p_er_tussises
predestinates1694635predestinates
preexcites2144165pre_e__xcites
preexisted2043785pre_e_xis_ted
preexists1844735pre_e_xis_t_s
prehensilities1962175prehensilities
premeditates1753755preme_ditates
prereleases1353165prereleas__es
preterites12411795prete___rites
preunites1138935p__re_u_nites
previsited1645185p__re_visited
previsits1446795p__re_visit_s
pyrolusites1652395p_yrolu_sites
requites171511765___requ__ites
reregister1143695_rere_gis_ter
reregisters1242855_rere_gis_ters
reregulates12135805_reregu_lates

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 Filter1786911247900.390458182.1
2DLD Change Limit124790399.14313648.7
3Display Results39390.0301300.0
 (SQL Overall)178691399.56318685.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.