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

48 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
refiguring154393(None) 
prefiguring1842931prefiguring
figuring1336282__figuring
refighting1845202refighting
refiring123513922refi__ring
befingering1843133befingering
configuring1853153configuring
disfiguring1752483disfiguring
figurine1245603__figurine
outfiguring1682243outfiguring
pedicuring1643243pedicuring
prefiring1559073prefi__ring
rearguing1135603reargu_ing
reassuring1155943reassuring
reconfiguring2061633reconfiguring
referring1338033ref_erring
refigure1254693refigur__e
refigured1443933refigur_ed
refigures1344543refigur_es
refiling123116533refi__ling
refilling13299333refi_lling
refilming15256463refi_lming
refiltering1544823refiltering
refinding14259943refi_nding
refining122416863refi__ning
refitting132811123refi_tting
refixing19329793refi__xing
refluxing2034583ref_luxing
refocusing1653853refocusing
refuging13218423ref__uging
refusing122310873ref__using
refuting121911903ref__uting
rehiring122911883rehi__ring
reigning1039883re_ig_ning
reinjuring1844423reinjuring
reinsuring1146383reinsuring
rejiggering2182333rejiggering
rejigging1933923rejig_ging
relighting1545853relighting
renaturing11176813renaturing
renigging1235573renig_ging
repouring12310073re_pouring
rerigging1236553rerig_ging
resecuring1345123resecuring
resighting1546073resighting
resigning1139463resig_ning
retiring92717413reti__ring
rewiring122911223rewi__ring

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603486.36022107.4
3Display Results48480.0163000.0
 (SQL Overall)178691486.78226347.8
 
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.