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

53 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
integrants114669(None) 
integrands1244121integrands
integrant1049831integrant_
integrals1046462integra_ls
integrand1145032integran_d
integrate10911152integra_te
integrates111010782integrates
intendants1145252intendants
interacts11312122inte_racts
intergrafts1544412intergrafts
intrants8312862int__rants
alterants979103alte_rants
entrants8311753ent__rants
immigrants1552073immigrants
inebriants1243863in_ebriants
inerrant8412483in_errant_
infestants1344503infestants
ingrafts12105803in__grafts
injectants1943283injectants
insurants947643in_surants
integrable1348403integrable
integral946783integra__l
integrality1554913integrality
integrally1445893integrally
integrated1289293integrated
integrator1157123integrator
integrators1246523integrators
integrity1345173integr_ity
integuments1454563integuments
intendant1047713intendant_
intents72115703inte___nts
interact10316463inte_ract_
intercuts1148783inte_rcuts
interests9312553inte_rests
intergang11117883intergan_g
intergrades1346783intergrades
intergraft1446173intergraft_
interknits1456203inte_rknits
interknots1455023inte_rknots
intermats111412453inte_rmats
interments12716213interments
intermits111212203inte_rmits
internals9712723inte_rnals
internes82721233inte_r_nes
interns73116773inte_r_n_s
interplants13116753interplants
interrupts1245743interrupts
intranets949263int__ranets
intrant7318753int__rant_
intrigants1145053intrigants
intriguants1252823intriguants
iterant7317783i_te_rant_
regrants9310013__regrants

Search took 7 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 Filter1786911406030.423422437.4
2DLD Change Limit140603535.75024452.7
3Display Results53530.0134076.9
 (SQL Overall)178691536.18628886.4
 
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.