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

52 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
integrals104647(None) 
integral946791integral_
integrable1348402integrable
integrally1445892integrally
integrand1145032integrand
integrands1244122integrands
integrant1049832integrant
integrants1146692integrants
integrate10911152integrate
integrates111010782integrates
internals9712732internals
intervals12810152intervals
inthrals11258502int_hrals
enteral73516453ente_ral_
enthrals11278903ent_hrals
illegals954323illeg_als
inaugurals1151873inaugurals
integers937783integ_ers
integrality1554913integrality
integrated1289293integrated
integrator1157123integrator
integrators1246523integrators
integrity1345173integrity
interact10316473inte_ract
interacts11312123inte_racts
interage9314493inte_rage
intergang11117893intergang
intergrade1247363intergrade
intergrades1346783intergrades
intergraft1446173intergraft
intergrafts1544413intergrafts
interims101013073inte_rims
interlap1048593inte_rlap
interlaps1148233interlaps
interlay11310043inte_rlay
interlays1248083interlays
intermale11712313intermale
intermats111412453intermats
internal8414093internal_
internes82721233inte_rnes
interns73116773inte_r_ns
interrace11312553interrace
inters64328053inte_r__s
interval11710473interval_
intervale12911603intervale
intervales131010513intervales
inthral10249463int_hral_
inthrall11247063int_hrall
inthralls12216233int_hralls
laterals8312753late_rals
literals8312293lite_rals
minerals10311393min_e_rals

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.440406115.9
2DLD Change Limit148641527.17020731.0
3Display Results52520.0331575.8
 (SQL Overall)178691527.64323379.7
 
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.