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

90 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
increase106645(None) 
increased1245541increased
increaser1154571increaser
increases1157381increases
increate10312201increate
crease85519572__crease
decrease1136572decrease
incase83615282inc__ase
incense92410302inc_ense
increasers1243312increasers
uncreate10311352uncreate
acreage1037843_acreage
ancress978613ancre_ss
ancresses1138413ancresses
cease75227653__c_ease
cocreate122611813cocreate
creased104315593__creased
creaser94415743__creaser
creases94020963__creases
creasy114612303__creasy
create85126383__create
creese84014333__creese
decease1049523dec_ease
decreased1345463decreased
decreases1237233decreases
degrease1045413degrease
encase83714363enc__ase
enchase1239473enc_hase
grease75416233__grease
idocrase1183603idocr_ase
imprese1138143impre_se
inbreathe1443623inbreathe
inbreds10245733inbreds_
incage93513623inc__age
incarnate1157223incarnate
incased103612393inc__ased
incases93615973inc__ases
incensed11277953inc_ensed
incenses102411003inc_enses
incest82918743inc_e_st
inchers123912523inchers_
inches114419673inche_s_
inchoate1347673inchoate
incise83515333inc__ise
inclasp1145303inc_lasp
inclose9910223inc_lose
incorpse1244703incorpse
increasable1555393increasable
increasing1346323increasing
incross937663incr_oss
incrossed1244753incrossed
incrosses1146043incrosses
incrust949203incr_ust
incubate1238663incubate
incudate1138873incudate
incurvate1446063incurvate
incuse83513573inc__use
ingrate8715123ingr_ate
ingress838653ingre_ss
ingresses1038533ingresses
inphase1245393in_phase
intense72511903in_tense
interage9314493interage
intreat7416303intrea_t
intreated10312663intreated
intreats8311543intreats
introrse846043introrse
inulase739413in_ulase
inurbane1045253inurbane
inures63318953inure_s_
inverse10249643in_verse
invertase1245833invertase
inweave1344723in_weave
miscreate1348893miscreate
nuclease1046213nuclease
ocreae83310273_ocrea_e
ocreate93711743_ocreate
pancreas1235393pancreas_
pancreases1443763pancreases
precrease1345233precrease
recreate10313603recreate
sucrase9310343sucr_ase
surcease1086883surcease
uncase83817433unc__ase
uncrate9415953uncr_ate
uncreated12312303uncreated
uncreates11310433uncreates
unease63816643un__ease
ungreased1136333ungreased
urease64516993__urease

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 Filter1786911461620.453394461.4
2DLD Change Limit146162907.29620033.2
3Display Results90900.0303000.0
 (SQL Overall)178691907.77922970.9
 
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.