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

58 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
internists1041024(None) 
internist9414881internist_
interdicts1347082interdicts
interests9312552inter_ests
interknits1456202interkni_ts
intermits111212202intermi_ts
intertwists1454292intertwists
eternises9119453_eternises
inherits11310103inher_i_ts
innermosts1242933innermosts
innerness946913innernes_s
intensity1247203inte_nsity
intents72115703inte_n__ts
interacts11312123inter_acts
intercaste1249283intercaste
intercepts1448633intercepts
intercity14410003interci_ty
intercuts1148783inter_cuts
interdict12410213interdict_
interest8319183inter_est_
interfiles1349993interfiles
interfuses1347683interfuses
interims101013073inter_i_ms
interiors9513563inter_iors
interjects1947533interjects
interknit1358333interkni_t_
interknots1455023interknots
interlines101116453interlines
interlinks14137503interlinks
intermats111412453inter_mats
interments12716213interments
intermit101213593intermi_t_
intermixes1948393intermixes
internalises12149113internalises
internals9712723intern_als
internees93014843intern_ees
internes82721233intern__es
interning10315253interni_ng
internments13510283internments
internodes1148673internodes
interns73116773intern___s
interposes12410563interposes
interprets1249333interprets
interrupts1245743interrupts
intersects1249153intersects
interties9320333interti_es
intertills1048223intertills
intertwist1356303intertwist_
interunit959833interuni_t_
interviews1645263interviews
intimists1147493int_imists
introits859713int_roi_ts
intrusts837723int_r_usts
intwists1145593int__wists
inverness1247133invernes_s
lutenists956593lute_nists
modernists1344293modernists
tennists8297793__tennists

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.403443402.0
2DLD Change Limit140603586.31622261.4
3Display Results58580.0301933.3
 (SQL Overall)178691586.74926476.7
 
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.