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

123 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
intenser819944(None) 
intender93310441intender
intense72511901intense_
immenser1244172immenser
incense92410302incense_
incensed11277952incensed
incenses102411002incenses
incenter102212092incenter
indenter92311442indenter
integer837992inte_ger
intended102310412intended
intenders10219372intenders
intensely1245392intensely
intensest949102intensest
intersex15209732intersex
intoner7811672inton_er
inventer112410842inventer
tenser64919432__tenser
anteater8311603anteater
attender935913attender
censer84516583__censer
condenser1287413condenser
contender1239563contender
denser74115193__denser
dispenser12128323dispenser
distender11167743distender
engender1046633engender
entente7412953entente_
ententes8312773ententes
enterer72015633ente_rer
extender16146333extender
extensor1543913extensor
flenser1036783_flenser
immense1135293immense_
inaner62213543in_an_er
incented112412543incented
incenters112510303incenters
incloser10106733incloser
increaser1154573increaser
indene73215373inden_e_
indenes82916253inden_es
indented101811733indented
indenters102710033indenters
indentor9288513indentor
indexer15287253inde_xer
indorser985713indorser
infecter13229153infecter
inferrer11217443inferrer
infester11239433infester
infuser10298323in_fuser
ingenue847133ingenue_
ingenues947103ingenues
inlander937223inlander
inner54920633in__n_er
insaner7310443insan_er
inserter82312133inserter
insetter8218593insetter
instanter946243instanter
integers937783inte_gers
intend72310373inten__d
intendeds11265743intendeds
intends8239963inten_ds
intensifier14113493intensifier
intensify1543993intensify
intension948493intension
intensity1247203intensity
intensive1248403intensive
intensives1347393intensives
intent63122773inten__t
intently1149823intently
intents72115703inten_ts
inter55028493int___er
interbed112413103interbed
interest8319183interest
interfere12410813interfere
interior8513113interior
interne73218153interne_
interned93016653interned
internee82718523internee
internees93014843internees
internes82721233internes
interns73116773interns__
interposer1248113interposer
interred92615263interred
interrex15249823interrex
inters64328053inters__
intersect11412113intersect
interterm1148813interterm
interwar1148263interwar
intine61021983intin_e_
intines7921113intin_es
intone61115433inton_e_
intoned8811993inton_ed
intoners889933inton_ers
intones7816543inton_es
intruder945213intruder
invented122510663invented
inventers12269533inventers
inventor11298153inventor
inverse10249643inverse_
inversed12269283inversed
inverses112410983inverses
inverter112411073inverter
licenser10155883licenser
listener8158313listen_er
oftener1035923often_er
sentencer1156383sentencer
teaser65421523__teaser
tender74121843__tender
tenner64117103__tenner
tense55225843__tense_
tensed74817833__tensed
tenses64722553__tenses
tensor63812673__tensor
tenter64623933__tenter
terser67317823__terser
untended102611153untended
untented92613413untented
untether1145163untether
vintner1034833vint_n_er
winterer112110443winte_rer
winterier1238343winterier
witnesser12224533witnesser

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621236.64322002.4
3Display Results1231230.0432860.5
 (SQL Overall)1786911237.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.