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

317 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
introns7351502(None) 
intron64215021intron_
intros64215771intro_s
biotrons1037232biotrons
cistrons102710622cistrons
citrons92913222citrons
diatrons939612diatrons
enterons8314152enterons
ignitrons1042992ignitrons
incross937662incross
inions64417002in_ions
inruns6359512in_runs
interns73116772interns
inthrone1179472inthrone
inthrones1299672inthrones
intone61115432int_one
intones7816542int_ones
intorts7310972intorts
intrant7318752intrant
intrants8312862intrants
intro54915852intro__
introfy1344752introfy
introit7414532introit
introits859712introits
introrse846042introrse
inturns73210132inturns
inurns63310982inur_ns
irons55324132i__rons
linurons846332linurons
matrons93517632matrons
natrons73215662natrons
nitons64614902nit_ons
nitros64214122nitro_s
nitrous73512482nitrous
patrons93818102patrons
actions94218513actions
ailerons849853ailerons
andirons948423andirons
andros7313303andro_s
anions64123033an_ions
antlions839193antlions
antres65021003antr_es
antrorse846933antrorse
antrums969173antrums
anurans73810553anurans
anurous7311553anurous
anyons94513503an_yons
aprons8316993_aprons
attorns738443attorns
barons85025383_barons
batons85519423bat_ons
benthons1337973benthons
betons84919553bet_ons
bicrons113410473bicrons
binturong12112073binturong
binturongs1391253binturongs
biotron937293biotron_
bistros92810983bistro_s
borons85520543_borons
burtons9310853burtons
buttons9310333buttons
cantons95221203cant_ons
cartons94122473cartons
cations94524143cations
cinerins10414103cinerins
cistron9299883cistron_
citrins92614363citrins
citron83112983citron_
citrous93112993citrous
controls10311393controls
cottons9312193cottons
cytons111710183cyt_ons
dacrons103211033dacrons
dendrons1047393dendrons
diatron839283diatron_
dictions111812673dictions
dineros83812333dinero_s
diurons838823diurons
dynatrons1343393dynatrons
einkorns1243343einkorns
enations83316903enations
endrins8312163endrins
engross837123engross
enrols61213383en_rols
enteron7313343enteron_
enthrone111110113enthrone
enthrones12910073enthrones
entrains8312963entrains
entrant7318873entrant
entrants8311753entrants
entraps9109763entraps
entrees71813773entrees
entries71523163entries
entropy1247353entropy
environs1144673environs
estrins7315853estrins
estrone7413953estrone
estrones8313323estrones
estrous7712533estrous
fenurons1174963fenurons
fictions132410743fictions
frons86124043__frons
futons93911513fut_ons
garrons82713463garrons
girons75014373_girons
gnomons1035753gnomons
gyrons105511223_gyrons
hadrons113314303hadrons
herons94820543_herons
hotrods1148283hotrods
icons76516493i__cons
ignitions1045803ignitions
ignitron943203ignitron_
ikons96311013i__kons
imbrowns1543263imbrowns
improvs1435003improvs
inactions1139323inactions
inarms8410093inar_ms
inborn8319143inborn_
inbreds10245733inbreds
incogs937903in_cogs
incony1139083in_cony
indols74714203in_dols
indoors838553indoors
indows104210793in_dows
indris7311963indr_is
inerts64517023iner_ts
infernos1145903infernos
inflows1335523inflows
informs1248073informs
infos84311673in_fo_s
ingots7912063in_gots
ingrains948983ingrains
ingress838653ingress
inground1044383inground
ingroup1044333ingroup
ingroups1143483ingroups
ingrown1145393ingrown
inion54620183in_ion_
inkhorns1543583inkhorns
inkpots1335173inkpots
inns46920933in___ns
inro45920793in_ro__
inroad737933in_road
inroads837043in_roads
inrun52911373in_run_
inspans937803inspans
instroke1245583instroke
instrokes1345353instrokes
intakes11310943intakes
intend72310373int_end
intends8239963intends
intense72511903int_ense
intent63122773int_ent
intents72115703intents
intercoms1349333intercoms
interims101013073interims
interiors9513563interiors
interjoins1747953interjoins
interloans1048263interloans
intermont11513573intermont
intern64016543intern_
interne73218153interne
internes82721233internes
inters64328053int_ers
interzone1849363interzone
inthrals11258503inthrals
inthroned1396583inthroned
intimas9119583intimas
intine61021983int_ine
intines7921113intines
intis55121643int__is
into45026153int_o__
intomb1036403int_omb
intombs1144153intombs
intoned8811993int_oned
intoner7811673int_oner
intoners889933int_oners
intort6418923int_ort
intown936153int_own
intrados946563intrados
intranet8418443intranet
intranets949263intranets
intreat7416303intreat
intreats8311543intreats
intrench1396593intrench
intrinsic1143583intrinsic
introfies1247233introfies
intromit1048743intromit
intromits1166213intromits
intrude837403intrude
intrudes937493intrudes
intrusions1046333intrusions
intrust7311493intrust
intrusts837723intrusts
intuits7310313intuits
inturn63411563inturn_
intwine1038513intwine
intwines1138043intwines
inulins7311493inulins
inures63318953inur_es
inuring81213013inuring
inurn53712863inur_n_
inwraps12105253inwraps
ions46737853i___ons
iron46728463i__ron_
irone55126363i__rone
irones64724013i__rones
irony85015903i__rony
isogons8217613isogons
jetons134512613jet_ons
jettons1437273jettons
kations114013663kations
kenotrons1344523kenotrons
ladrons83813193ladrons
lintols7339553lint_ols
linuron746513linuron_
lotions74614763lotions
macrons113514893macrons
marrons93216973marrons
matron83918313matron_
mentions10312893mentions
metros84217803metro_s
microns113814783microns
midirons1145883midirons
mikrons13428413mikrons
minions93314623min_ions
monurons1037093monurons
morons84919543_morons
motions94215003motions
mutons84314363mut_ons
muttons949283muttons
nations74720563nations
natron64116023natron_
neons55818683_n_eons
nerols6914883_nerols
neurons7410443neurons
neutrons838293neutrons
nimrods1044283nimrods
ninons64913773_ninons
niton55418283nit_on_
nitres65519333nitr_es
nitrids8269633nitrids
nitrils72810703nitrils
nitro54914353nitro__
nitrogens1045353nitrogens
nitroso7326453nitroso
noons54125283_n_oons
notions74014483notions
nylons9267973_nylons
octrois938333octrois
onerous7312973onerous
onions64016433on_ions
operons91411743operons
options93810603options
outrows10311403outrows
outruns72911543outruns
partons94620513partons
patrols93513513patrols
patron84018043patron_
patroons102710603patroons
perrons93115483perrons
petrols92913083petrols
petrous92714423petrous
pinions93413603pin_ions
pinons86019943pin__ons
pintanos10107553pintanos
pintoes95117713pint_oes
pintos86021293pint_o_s
pinyons12299003pin_yons
pistons93016373pist_ons
pitons85319043pit_ons
pliotrons1144703pliotrons
pontons93315553pont_ons
pontoons10279313pontoons
potions93417423potions
putons83515153put_ons
pythons1537363pythons
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
retros63820193retro_s
setons64620173set_ons
strong74914883_strong
strops86220383_strops
strows96718273_strows
stroys95914603_stroys
thorons104511913thorons
tinhorns1145013tinhorns
tons46553053__t_ons
toons55027533__toons
trans54933043__trans
trogs67022603__trogs
trois57226093__trois
trona54118953__trona
tronas63816903__tronas
trone55131863__trone
trones65629283__trones
trots56629943__trots
trows88826183__trows
troys86418613__troys
uncross938193uncross
uncrowns1344363uncrowns
unctions1039733unctions
unions64216753un_ions
unisons748423unisons
unthrone11128183unthrone
unthrones1297383unthrones
untorn63012343untorn_
untrims938613untrims
untrod769853untro_d
untruss736553untruss
vignerons1343163vignerons
waitrons1136633waitrons
wantons103713013want_ons
windrows1546163windrows
wontons103310533wont_ons

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 Filter1786911340270.390458182.1
2DLD Change Limit1340273176.64020184.8
3Display Results3173170.1262515.9
 (SQL Overall)1786913177.15624970.8
 
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.