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

202 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
interring1031542(None) 
inferring1338611inferring
interning10315251interning
cointerring1447152cointerring
deterring1138622deterring
entering91920052ente_ring
incurring1236872incurring
inhering12913712inhe_ring
innerving1346502innerving
inserting10914242inserting
instarring1144062instarring
intending1139982intending
interfering1558922interfering
intergang11117892intergang
interline91218022interline
interlink131310662interlink
intorting10311422intorting
inversing1389622inversing
inverting131013222inverting
reinterring1245362reinterring
sintering101014802sinte_ring
unerring9311272un_erring
wintering13412362winte_ring
altering91917123alte_ring
anearing9413973an_earing
angering102113803ange_ring
anteing8312813ante__ing
averring12239063_averring
bantering122414243bante_ring
bittering122512003bitte_ring
cantering122417383cante_ring
catering112019923cate_ring
centering122915143cente_ring
cindering13311223cinde_ring
coinferring1744203coinferring
conferring1648743conferring
deferring1436143deferring
deterging1237853deterging
disinterring1454203disinterring
endearing1139323endearing
enserfing1345893enserfing
erring73816483___erring
filtering13199723filte_ring
fingering1439193finge_ring
fingerling1544833fingerling
gingering1238873ginge_ring
gnarring10225973gn_arring
herring113615883__herring
hindering14310273hinde_ring
immerging1544103immerging
immersing1445123immersing
inarming1138343in_arming
inbeing1038333inbe__ing
incensing1297663incensing
incenting12912063incenting
incepting1489303incepting
incurving1545373incurving
indenting11911263indenting
indexing1737123inde_xing
indorsing1137143indorsing
inerrant8412493in_errant
infecting15109673infecting
infesting13109513infesting
infirming1545163infirming
informing1537023informing
ingesting11129623ingesting
inheriting1448853inheriting
injecting1997693injecting
injuring1637473in_juring
inletting1087873inletting
inmeshing1595333inmeshing
innerspring1452653innerspring
inpouring1236393inpouring
inquiring19155643inquiring
insetting1079283insetting
insnaring1046313insnaring
inspiring1246183inspiring
insuring9311153in_suring
integrand1145033integrand
integrant1049833integrant
integrating1349493integrating
integrity1345173integrity
interabang1344483interabang
interacting14411713interacting
interarching1845013interarching
interbank1547043interbank
interceding1568043interceding
intercity14410003intercity
interdict12410213interdict
interesting12411123interesting
interfacing1747703interfacing
interfile12411043interfile
interfiling1546953interfiling
interfirm1446453interfirm
interfusing1555833interfusing
intergrading1545983intergrading
interim9912873inte_ri_m
interims101013073inte_rims
interior8513113inte_rior
interjoin1647893interjoin_
interjoins1747953interjoins
interknit1358333interknit
interlacing1449053interlacing
interlarding1445563interlarding
interlaying1547573interlaying
interlend10310123interlend
interlent9416743interlent
interlined111211273interlined
interliner101311173interliner
interlines101116463interlines
interlining1249133interlining
interlinks14137503interlinks
interloping1446963interloping
interment11419223interment
intermingle1445763intermingle
intermit101213593intermi_t
intermits111212203intermits
intermix17156873intermi_x
intermixing2146613intermixing
intermont11513573intermont
intern64016543inte_r_n_
interne73218153inte_r_ne
internist9414883internist
interns73116773inte_r_ns
interpoint12411883interpoint
interposing1447803interposing
interpreting1588303interpreting
interrace11312553interrace
interred92615263interr_ed
interregna1155073interregna
interrenal1049823interrenal
interrex15249823interr_ex
interrobang1453653interrobang
interrow1147143interr_ow
interrupt1147243interrupt
interrupting1546243interrupting
intertie8317613interti_e
interties9320343interties
intertill9410423intertill
intertrial1049523intertrial
intertwine1347623intertwine
interunit959843interunit
intervene12912263intervene
intervening1548173intervening
interview1547363interview
interworking2054523interworking
interzone1849373interzone
intestine9411863intestine
inthroning1446223inthroning
intitling1037223intitling
intombing1444613intombing
intoning9311123int_oning
intreating11614013intreating
intruding1146873intruding
intuiting1089613intuiting
intwining1345883intwining
inuring81213013in__uring
inurning937553in_urning
inventing13109973inventing
invertin11910233invertin_
invertins12911023invertins
investing13119393investing
inweaving1644773inweaving
iteming1037753i_te_ming
iterating10314253i_terating
jittering17218423jitte_ring
lingering11310513linge_ring
littering102411983litte_ring
metering112915633mete_ring
misinterring1553503misinterring
misterming1538603misterming
mitering113015403mite_ring
nearing83020333_n_earing
nerving112910833_n_erving
nidering10510483nide_ring
petering112516813pete_ring
referring1338033referring
retearing102214253retearing
sistering101213753siste_ring
sneering93414503sn_eering
starring92312953_starring
steering93916793_steering
sterling93615553_sterling
stirring9299653_stirring
tarring83318303__tarring
tearing84021493__tearing
tentering102313213tente_ring
terming104016003__terming
terrine72517573__terrine
tinkering1437703tinke_ring
tittering102310313titte_ring
unbarring1236063unbarring
unbearing1239353unbearing
underling111514613underling
underwing141410883underwing
unfearing1338883unfearing
unnerving1336633unnerving
untiring9312003unt_iring
uptearing1236103uptearing
uttering91613083utte_ring
watering122316323wate_ring
winterizing2446053winterizing

Search took 9 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 Limit1486412027.46619909.1
3Display Results2022020.0962104.2
 (SQL Overall)1786912027.99822342.0
 
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.