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

72 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
transfecting185516(None) 
transecting1447371trans_ecting
transacting1446522trans_acting
transfection1765392transfection
transfections1854852transfections
transferring1654332transferring
trajecting2044293tra__jecting
transcending1653833transcending
transducing1554353transduc_ing
transection1357373trans_ection
transections1446763trans_ections
transfect1446733transfect___
transfected1745353transfect_ed
transfects1545723transfect__s
transferrin1454773transferrin_
transferrins1554583transferrins
transfixing2254803transf_ixing
transforming1854643transforming
transfusing1554673transf_using
transiting11410773trans__iting
translating1249433trans_lating
translocating1654283translocating
transmitting1556093transmitting
transmuting1456223trans_muting
transporting1555783transporting
trisecting1345503tr_is_ecting
affecting1845234__a_ffecting
coinfecting1944574coin_fecting
confecting18310554_con_fecting
infecting15109674__in_fecting
inspecting1546224__inspecting
manifesting1762734_manifesting
praelecting1644534pra_electing
prosecting15189814pr_os_ecting
prospecting1845854pr_ospecting
ransacking1744424_rans_acking
redefecting1844374_redefecting
refecting152413354_r__efecting
reinfecting1745154_reinfecting
reinspecting1763204reinspecting
resecting122816484_r_es_ecting
respecting1549884_r_especting
retransferring1881554retransferring
trafficking2451784tra_fficking
trancing112812024tran___c_ing
transaction1346304trans_action
transactions1445884trans_actions
transcribing1754244transcribing
transductant1573574transductant
transduction1584454transduction
transductions1664294transductions
transect10410054trans_ect___
transected1347314trans_ect_ed
transects1157824trans_ect__s
transfiguring1862684transfiguring
transgressing1562694transgressing
transhipping2073224transhipping
transpiercing1862844transpiercing
transpiring1446874trans_piring
transplanting1663944transplanting
transpontine1465134transpontine
transposing1455454trans_posing
transshaping1863494transshaping
transuding1246004trans__uding
transvaluing1653424transvaluing
transvestism1762954transvestism
transvestite1553924transvestite
trapnesting1453144tra_pnesting
trapshooting1852504trapshooting
trendsetting1451394trendsetting
trinketing1544154trin_ke_ting
unaffecting2052164una_ffecting

Search took 8 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.1401276364.3
2DLD Change Limit124790727.20317324.7
3Display Results72720.0461565.2
 (SQL Overall)178691727.38924183.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.