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

60 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
transfiguring186268(None) 
transferring1654333transf_erring
transfigure1553433transfigur__e
transfigured1752453transfigur_ed
transfigures1653253transfigur_es
transfixing2254803transfi__xing
transfusing1554673transf__using
transpiring1446873transpi__ring
configuring1853154_con_figuring
disfiguring1752484__disfiguring
prefiguring1842934pr__efiguring
refiguring1543934_r__efiguring
transducing1554354trans__ducing
transfecting1855164transf_ecting
transferrin1454774transf_errin_
transferrins1554584transf_errins
transfiguration1962224transfiguration
transforming1854644transf_orming
transhipping2073224transhi_pping
transiting11410774trans_i__ting
transmigrating1863084transmigrating
transmitting1556094transmi_tting
transmuting1456224trans__muting
transpiercing1862844transpiercing
transuding1246004trans___uding
transvaluing1653424transvalu_ing
figuring1336285_____figuring
manicuring1543945_man__icuring
outfiguring1682245__outfiguring
reconfiguring2061635reconfiguring
retransferring1881555retransf_erring
strangering1345195stran___gering
tonsuring1046505t_ons___uring
trafficking2451785tra_ffi_cking
trailering1145725tra___ilering
tranquilizing3262675tranquilizing
transacting1446525trans__acting
transcending1653835trans_cending
transcribing1754245trans_cribing
transecting1447375trans__ecting
transfinite1455505transfi__nite
transfixion2154205transfi__xion
transfixions2253935transfi_xions
transfusion1454235transf__usion
transfusions1553935transf__usions
transgressing1562695transgressing
transitorily1554055trans_itorily
translating1249445trans__lating
transliterating1691865transliterating
translocating1654285translocating
transmarine1357575trans__marine
transmigrate1554125transmig_rate
transmogrify2161945transmog_rify
transplanting1663965transplanting
transporting1555785trans_porting
transposing1455455trans__posing
transshaping1863495trans_shaping
transshipping2162025transshipping
transvaluating1862735transvaluating
treasuring1144705treas___uring

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.406440125.6
2DLD Change Limit124790609.36013332.3
3Display Results60600.0461304.3
 (SQL Overall)178691609.81218211.5
 
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.