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

134 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
interiors951357(None) 
inferiors1266541inferiors
interior8513101interior_
anterior8611062anterior_
exteriors1647332exteriors
inferior1156422inferior_
inheritors1345632inheritors
intercoms1349332intercoms
interims101013072interi_ms
interiorise1148102interiorise
interiorly1347042interiorly
interwork1647082interwork
interworks1746702interworks
invertors12239792invertors
anteriorly1354033anteriorly
anterooms11119603anterooms
bioterrors1252693bioterrors
enterers82214153enter_ers
enterics10312853enteri_cs
enteritis9411313enteritis
enterons8314153enter_ons
exterior1547383exterior_
icterics1247073icteri_cs
imperious1346583imperious
inceptors1345783inceptors
incurious1145693incurious
indentors10278313indentors
indorsors1043683indorsors
infectors14218553infectors
inferiorly1653123inferiorly
infernos1145903inferno_s
inferrers12226583inferrers
ingenious1046013ingenious
inheritor1245633inheritor_
inherits11310103inheri_ts
inhesions12116123inhesions
injectors18216723injectors
injurious1643763injurious
inserters92210283inserters
insertions10410343insertions
integers937783inte_gers
integrators1246523integrators
intenders10219373intenders
intensions1048403intensions
intentions10411403intentions
interacts11312123interacts
interbeds12238903interbeds
intercom1248683interco_m
intercourse1355013intercourse
intercrop1345763intercrop
intercrops1446003intercrops
intercross1246213intercross
intercuts1148783intercuts
interdictors1554453interdictors
interdicts1347083interdicts
interests9312553interests
interfere12410813interfere
interferes1349983interferes
interfiles1349993interfiles
interfirm1446443interfirm
interflows1644703interflows
interfold13137483interfold
interfolds14126143interfolds
interim9912873interi__m
interionic1248263interionic
interiorised1355183interiorised
interiorises1296883interiorises
interiority1456963interiority
interiorize2056343interiorize
interiorizes2155693interiorizes
interjoin1647893interjoin
interjoins1747953interjoins
interknots1455023interknots
interlaps1148233interlaps
interlard1048453interlard
interlards1146813interlards
interlays1248083interlays
interliners11138693interliners
interlines101116453interlines
interlinks14137503interlinks
interloan948773interloan
interloans1048263interloans
interlock1546233interlock
interlocks1645973interlocks
interloop1145833interloop
interloops1245483interloops
interlope1149183interlope
interlopers1346193interlopers
interlopes1249273interlopes
intermats111412453intermats
intermits111212203intermits
intermixes1948393intermixes
intermont11513573intermont
internals9712733internals
internees93014843internees
internes82721233inter_nes
internists10410243internists
internode1048763internode
internodes1148673internodes
interns73116773inter__ns
interpose11410463interpose
interposers1346263interposers
interposes12410563interposes
interrow1147143interro_w
inters64328053inte___rs
interterm1148813interterm
interties9320343interties
intertills1048223intertills
intervals12810153intervals
intervenors14105473intervenors
interviews1645263interviews
interwar1148263interwar_
interwove1547143interwove
interzone1849363interzone
introits859713int_roits
introns73515023int_r_ons
introrse846043int_r_orse
intros64215773int_r_o_s
inventors12288253inventors
inversions1347003inversions
inverters12239753inverters
invertor11238973invertor_
investors12227723investors
niteries8318383niteri_es
posteriors1256833posteriors
stertors8310933_stertors
superiors11410963superiors
termors94712773__termors
terrors73112213__terrors
ulterior845453ulterior_
unserious946803unserious
winterers12209723winter_ers
winterier1238343winterier_
winterizes2247143winterizes

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 Limit1486411346.82621775.7
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.32524394.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.