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

95 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
incensing129766(None) 
incenting12912061incenting
censing104215262__censing
incanting1289902incanting
incasing11610602inc_asing
incepting1489292incepting
incising11411092inc_ising
inclosing1257652inclosing
increasing1346322increasing
incusing1159952inc_using
indenting11911262indenting
intending1139982intending
inventing13109972inventing
inversing1389622inversing
licensing1244752licensing
unceasing1239652unceasing
accenting1487823accenting
accessing1445833accessing
ascending1336283ascending
ceasing104118263__ceasing
cessing103814813__cessing
condensing1447743condensing
deceasing1338403deceasing
defensing14217003defensing
dispensing1448233dispensing
encasing11610823enc_asing
enchasing1567733enchasing
enclosing1257573enclosing
excessing1945713excessing
expensing1946003expensing
finessing1345123fin_essing
flensing1246973_flensing
immersing1445123immersing
impending1535933impending
inbeing1038333inbe__ing
incaging1288673inc_aging
incense92410303incens__e
incensed11277953incens_ed
incenses102411003incens_es
incentive1489603incentive
incessant1146093incessant
inching134414323inc__hing
inciting11312533inc_iting
inclasping1543803inclasping
inclining1248403inclining
including1344993including
incoming1349863inc_oming
incorpsing1544433incorpsing
incrossing1345023incrossing
incrusting13126473incrusting
incurring1236873incurring
incurving1545373incurving
indexing1737123inde_xing
indorsing1137143indorsing
infecting15109673infecting
inferring1338613inferring
infesting13109513infesting
infusing1237893in_fusing
ingesting11129623ingesting
inhering12913713inhe_ring
injecting1997693injecting
inletting1087873inletting
inmeshing1595333inmeshing
innerving1346503innerving
inning73617633in__n_ing
inserting10914243inserting
insetting1079283insetting
intensify1543993intensify
intension948493intension
intensions1048403intensions
intensity1247203intensity
intensive1248403intensive
interning10315253interning
interring10315423interring
intoning9311123inton_ing
inurning937553inurn_ing
inverting131013223inverting
investing13119393investing
inweaving1644773inweaving
inwinding1445173inwinding
lensing84015103__lensing
licencing1443853licencing
mensing103915103__mensing
pinkening1634993pinken_ing
recessing12611013recessing
scending122610583_scending
scenting113212813_scenting
sensing84116953__sensing
tensing84616653__tensing
unbending1337463unbending
uncasing11511003unc_asing
unclosing1247753unclosing
unending10239943un_ending
unfencing1545953unfencing
unpenning1236183unpenning

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 Filter1786911486410.420425454.8
2DLD Change Limit148641957.33020278.4
3Display Results95950.0303166.7
 (SQL Overall)178691957.78022968.0
 
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.