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

86 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
integrate1091115(None) 
integrated1289291integrated
integrates111010781integrates
ingrate8715122in__grate
integrable1348402integrable
integral946782integra_l
integrals1046462integrals
integrand1145032integrand
integrant1049832integrant
integrants1146692integrants
integrative1547122integrative
integrator1157122integrator
integrity1345172integrity
intenerate1048732intenerate
interage9314482inte_rage
intergrade1247362intergrade
interrace11312542interrace
intestate9159872intestate
iterate71119112i_te_rate
reintegrate1274942reintegrate
antedate949683ante_date
disintegrate1453343disintegrate
immigrate1444353immigrate
impetrate1345723impetrate
inaugurate1153653inaugurate
indagate1047193indag_ate
indurate9311873in_durate
inebriate1146633in_ebriate
ingate73018243in__g_ate
ingrates9514173in__grates
innervate1246593innervate
insensate945383insensate
instigate1048613instig_ate
integrality1554913integrality
integrally1445893integrally
integrands1244123integrands
integrating1349493integrating
integration121310493integration
integrators1246523integrators
integrities1247783integrities
intemperate1555773intemperate
intenerated1247013intenerated
intenerates1148083intenerates
interact10316463inte_ract
interacted13411213inte_racted
interacts11312123inte_racts
intercaste1249273intercaste
intercrater1349233intercrater
interface14410163interface
intergang11117883intergang
intergraded1445633intergraded
intergrades1346783intergrades
intergraft1446173intergraft
intergrafted1753943intergrafted
intergrafts1544413intergrafts
interlace11311903interlace
intermale11712293intermale
intermat101114613intermat_
intermats111412453intermats
interne73218143inte_r_ne
internee82718513inte_rnee
interrelate11188973interrelate
interrogate1277613interrogate
interstate10710973interstate
intertie8317613inte_rtie
intervale12911583intervale
intestates10159433intestates
intimate101013833int_imate
intonate8310923int_onate
intricate11411193intricate
intubate1047533int_ubate
inveterate1345243inveterate
invigorate14134373invigorate
iterated91213823i_te_rated
iterates81317823i_te_rates
literate81216893lite_rate
negate72915573_n_eg_ate
nitrate72017013nit__rate
redintegrate1463183redintegrate
regrate82618663__regrate
reintegrated1474493reintegrated
reintegrates1374943reintegrates
stearate839723_stearate
underate9918603unde_rate
underrate10411893underrate
unintegrated1453303unintegrated

Search took 9 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.1561145455.1
2DLD Change Limit148641868.15618224.7
3Display Results86860.0332606.1
 (SQL Overall)178691868.34521412.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.