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 “internals” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
internals971272(None) 
internal8414081internal_
intervals12810131intervals
eternals8238952_eternals
externals1666622externals
infernal1186822infernal_
integrals1046462integrals
interlaps1148232interlaps
interlays1248082interlays
intermale11712292intermale
intermats111412452intermats
internalise111510552internalise
internally13410092internally
internees93014842internees
internes82721232intern_es
interns73116772intern__s
interval11710452interval_
intervale12911582intervale
intervales131010502intervales
inthrals11258502inthr_als
antennal856353antennal_
antennas846403antenna_s
arterials949693arterials
asternal858323asternal_
cisternal11325743cisternal_
enteral73516443enter_al_
enthrals11278903enthr_als
eternal72910893_eternal_
external1577223external_
fingernails1551643fingernails
imperials1347333imperials
infernally1645263infernally
infernos1145903infern_os
innerness946913innerness
integral946783integral_
integrands1244123integrands
integrants1146693integrants
intends8239963inte_n_ds
intently1149823inte_ntly
intents72115703inte_n_ts
interact10316463inter_act
interacts11312123interacts
interage9314483inter_age
interbank1547033interbank
interbeds12238903interbeds
intercell1148163intercell
interclan1148603interclan
interclass1246993interclass
intercoms1349333intercoms
intercuts1148783intercuts
interests9312553interests
interface14410163interface
interfaces15410403interfaces
interfile12411043interfile
interfiles1349993interfiles
interfold13137483interfold
interfolds14126143interfolds
intergang11117883intergang
interims101013073inter_ims
interiors9513563interiors
interknits1456203interknits
interknots1455023interknots
interlace11311903interlace
interlaces12412043interlaces
interlaid1049353interlaid
interlap1048593interla_p
interlard1048453interlard
interlards1146813interlards
interlay11310043interla_y
interloans1048263interloans
intermat101114613interma_t
intermits111212203intermits
intern64016543intern___
internalised13127043internalised
internalises12149113internalises
internality1448683internality
internalize20149593internalize
internalizes21138693internalizes
interne73218143intern__e
interned93016653intern_ed
internee82718513intern_ee
interning10315253interning
internist9414883internist
internists10410243internists
internodal1145873internodal_
internode1048763internode
internodes1148673internodes
interplay1447163interplay
interplays1545523interplays
interrace11312543interrace
interrenal1049813interrenal_
inters64328053inter___s
interties9320333interties
intertill9410423intertill
intertills1048223intertills
interwar1148263interwa_r
interzonal1946813interzonal_
inthral10249463inthr_al_
inthrall11247063inthr_all
inthralls12216233inthralls
intrants8312863int_rants
intreats8311543int_reats
inturns73210133inturn__s
inverness1247133inverness
laterals8312753later_als
literals8312293liter_als
materials11510793materials
maternal1047803maternal_
minerals10311373min_er_als
paternal1038333paternal_
sternal73411913_sternal_

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.436409841.7
2DLD Change Limit1486411117.16020759.9
3Display Results1111110.0601850.0
 (SQL Overall)1786911117.65623340.0
 
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.