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

82 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
intervals1281013(None) 
internals9712721internals
interval11710451interval_
intervale12911581intervale
intervales131010501intervales
integrals1046462integrals
interlaps1148232interlaps
interlays1248082interlays
intermale11712292intermale
intermats111412452intermats
internal8414082internal_
inthrals11258502inthr_als
arterials949693arterials
enteral73516443enter_al_
enthrals11278903enthr_als
eternals8238953_eternals
externals1666623externals
imperials1347333imperials
infernal1186823infernal_
innervate1246593innervate
innervates1346383innervates
innerves1158013innerv_es
integral946783integral_
interact10316463inter_act
interacts11312123interacts
interage9314483inter_age
interbank1547033interbank
interbeds12238903interbeds
intercell1148163intercell
interclan1148603interclan
interclass1246993interclass
intercoms1349333intercoms
intercuts1148783intercuts
interests9312553interests
interface14410163interface
interfaces15410403interfaces
interfile12411043interfile
interfiles1349993interfiles
interfold13137483interfold
interfolds14126143interfolds
intergang11117883intergang
interims101013073inter_ims
interiors9513563interiors
interlace11311903interlace
interlaces12412043interlaces
interlaid1049353interlaid
interlap1048593interla_p
interlard1048453interlard
interlards1146813interlards
interlay11310043interla_y
interloans1048263interloans
intermat101114613interma_t
intermits111212203intermits
internalise111510553internalise
internally13410093internally
internees93014843internees
internes82721233inter_nes
interns73116773inter__ns
interplay1447163interplay
interplays1545523interplays
interrace11312543interrace
inters64328053inter___s
interties9320333interties
intertill9410423intertill
intertills1048223intertills
intervalley1754693intervalley
intervallic1653383intervallic
intervene12912243intervene
intervenes131012643intervenes
interview1547363interview
interviews1645263interviews
interwar1148263interwa_r
inthral10249463inthr_al_
inthrall11247063inthr_all
inthralls12216233inthralls
intreats8311543int_reats
laterals8312753later_als
literals8312293liter_als
materials11510793materials
minerals10311373min_er_als
servals103410743__servals
subintervals1761133subintervals

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 Limit148641827.18620684.8
3Display Results82820.0332484.8
 (SQL Overall)178691827.65523343.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.