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

52 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
recirculating185353(None) 
circulating1647732__circulating
recalculating1853642recalculating
recirculation1764902recirculation
recirculations1884222recirculations
reticulating1546392reti_culating
noncirculating1961753noncirculating
recircling1543573recirc_l__ing
recirculate1554703recirculat__e
recirculated1753953recirculat_ed
recirculates1654073recirculat_es
reformulating1972823reformulating
reinoculating1653583reinoculating
vesiculating1844673vesi_culating
acidulating1544294_aci_dulating
articulating1556764arti_culating
calculating1666794__calculating
circuiting1545364__circu_iting
circulation1549394__circulation
circulations1648484__circulations
circulative1855564__circulative
ejaculating2144834_e_jaculating
emasculating1754304_emasculating
gesticulating1773944gesticulating
matriculating1863984matriculating
mercurating1645954me__rcurating
peculating1549164pe___culating
percolating1657324pe__rcolating
preformulating2281874preformulating
rearticulating1753694rearticulating
recalculation17114594recalculation
recalculations18104034recalculations
recapitulating1962054recapitulating
reciprocating2052854reciprocating
reconsulting1554214reconsul_ting
recrating121318794rec_r___ating
recreating131214584rec_r__eating
recriminating1864934recriminating
recruiting1347904rec_r_u_iting
redictating1546804redi_c_tating
reescalating1553254re_escalating
regulating12310064re___gulating
reinflating1545994re_i_nflating
repopulating1744484re_populating
reregulating1454644re_regulating
resculpting1643454re__sculpting
resituating1247544resi_tu_ating
restimulating1654134restimulating
reticulation1448054reti_culation
reticulations1556614reti_culations
reviolating1556264revi__olating
uncalculating1851954uncalculating

Search took 6 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 Filter178691950240.360496363.9
2DLD Change Limit95024525.33017828.1
3Display Results52520.0301733.3
 (SQL Overall)178691525.72031239.7
 
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.