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

355 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
inserts7401399(None) 
inerts64517021in_erts
insects93710841insects
insert64325251insert_
insets64016131inse_ts
inverts103211951inverts
asserts74311792asserts
deserts82513052deserts
disserts92411812disserts
enserfs1035482enserfs
exserts1467012exserts
incents92414532incents
incepts11238282incepts
incests92711382incests
indents83114662indents
inert53234372in_ert_
infects12279712infects
infers93615442infer_s
infests10279792infests
ingests83210982ingests
inheres10315172inheres
inherits11310102inherits
injects16257452injects
inkers104018832inker_s
inlets63915572inle_ts
inners63919342inner_s
inseams9307902inseams
insect83916582insect_
inserted92413052inserted
inserter82312132inserter
inserters92210282inserters
inset54430862inse_t_
insists739082insists
inspects1255862inspects
insults7268962insults
insures73117262insures
intents72115702intents
interns73116762interns
inters64328042inter_s
intorts7310962intorts
invents102812052invents
invert94120082invert_
invests10319682invests
nerts55924982_n_erts
onsets64013542onse_ts
reinserts946422reinserts
rinsers73815742rinser_s
unseats73012852unseats
unsets64116162unse_ts
absents93510723absents
adverts11308513adverts
ainsells895403ainsells
alerts64418223_alerts
angers75222543anger_s
anserous8410533anserous
answers1037043answer_s
assents74512223assents
assert64922573assert_
assets65617663asse_ts
assorts73310153assorts
averts95715243_averts
besets85718803bese_ts
binders103920743binder_s
biners85023633bin_er_s
bingers104519983binger_s
bisects1137133bisects
caserns94711213caserns
censers94313903censer_s
cherts115617233_cherts
cinders104617753cinder_s
concerts123016063concerts
consents102715893consents
consorts101512333consorts
converts133213553converts
cosets85824403cose_ts
coverts124813813coverts
desert72725493desert_
desserts9247923desserts
dineros83812333din_eros
diners75525953din_er_s
dingers94321373dinger_s
dinners83915433dinner_s
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
dissert83720693dissert_
diverts114412033diverts
dosers75723633doser_s
enders74324053ender_s
enserf9310763enser_f
ensures73315903ensures
enters64425643enter_s
everts94514893_everts
exerts133712293_exerts
experts1659063experts
exsects1655573exsects
exsert13414363exsert_
filberts1334983filberts
finders113717873finder_s
fingers113418423finger_s
gilberts1134173gilberts
gingers94118633ginger_s
ginners84314213ginner_s
ginsengs1042653ginsengs
hinders113718503hinder_s
hingers113420193hinger_s
hinters103719573hinter_s
hissers104112313hisser_s
hosers95223953hoser_s
ickers123914183icker_s
icterus936053icterus
idlers74012813idler_s
imarets9138643imarets
imparts11298533imparts
imports11309623imports
inarms8410093in_arms
inbreds10245733inbreds
inburst937163inburst
inbursts1044323inbursts
incants92012803incants
incent83320723incent_
incept102712753incept_
incest82918743incest_
inchers123912523incher_s
incurs83012273incur_s
indenes82916253indenes
indent73021243indent_
indexes15339453indexes
indicts103210723indicts
indris7311953in_dris
inducts10259573inducts
indults8289493indults
inearth1037033inearth
inearths1144933inearths
inept73622153in_ept_
inertia7410203in_ertia
inertias8410383in_ertias
inertly1038543in_ertly
inexperts1842963inexperts
infants102210773infants
infarcts1345233infarcts
infares10313023infares
infect113413443infect_
infer84215033infer__
inferno1045603inferno
infernos1145903infernos
infest93315433infest_
infirms1245563infirms
inflects1336193inflects
informs1248063informs
infusers11286143infuser_s
ingest73119003ingest_
ingesta8357863ingesta
ingots7912063in_gots
ingress838653ingress
inhere9313713inher_e
inhered11313163inhered
inherit10312973inherit
inject153210233inject_
injures143111173injures
inker94421093inker__
inkpots1335173inkpots
inlet53732403inle_t_
inliers73110743inlier_s
innards837153innards
inner54920623inner__
innerly1037123innerly
innerve1056733innerve
innerves1158013innerves
inputs837703in_puts
inquests1744943inquests
inseam8329993inse_am
insectan1045383insectan
inserting10914233inserting
insertion9410593insertion
insertions10410323insertions
insetted9249023insetted
insetter8218593insetter
insetters9187133insetters
insheath14114413insheath
insheaths15183503insheaths
insiders947753insider_s
insides8512653insides
insights1245493insights
insist6314503insist_
insnares858083insnares
insolents9137523insolents
insoles73516243insoles
insouls737213insouls
inspans937803inspans
inspect1138463inspect_
inspheres1455403inspheres
inspires1037623inspires
inspirits1144243inspirits
instals7611713instals
instants8910153instants
instars7411113instars
instate71616473instate
instates81615823instates
insteps936573insteps
instils7811453instils
instructs1145793instructs
insult62813673insult_
insurants947643insurants
insure63416603insur_e
insured83714253insured
insureds9277613insureds
insurer73312803insurer
insurers83710133insurers
inswept1245733inswept_
intends8239963intends
intent63122773intent_
inter55028493inter__
interacts11312123interacts
intercuts1148783intercuts
interest8319183interest
interests9312553interests
interim9912873interim
interims101013073interims
intermats111412453intermats
intermits111212203intermits
intern64016543inter_n
interne73218143interne
internes82721233internes
intertie8317613intertie
interties9320333interties
intort6418923intort_
intreats8311543intreats
intros64215773in_tros
intuits7310313intuits
inturns73210133inturns
inures63318953in_ures
inurns63310983in_urns
invars9310003invar_s
invent93316363invent_
inverity1447963inverity
inverse10249643inverse
inverses112410983inverses
invertase1245823invertase
inverted122312163inverted
inverter112411073inverter
inverters12239753inverters
invertin11910233invertin
invertins12911023invertins
invertor11238963invertor
invertors12239773invertors
invest93014843invest_
inwards1138343inwards
islets64513083i_slets
isseis638563isse_is
issuers746123issuer_s
jinkers183511813jinker_s
kissers114211293kisser_s
lasers64925703laser_s
liners65428843lin_er_s
lingers84223293linger_s
linkers114317703linker_s
linnets739823linne_ts
linseeds944733linseeds
linseys1035083linse_ys
linters73822613linter_s
losers65123583loser_s
masers84623453maser_s
minarets1048833minarets
mincers113714843mincer_s
minders103720113minder_s
mindsets1135683mindse_ts
miners84126633min_er_s
minsters103813913minster_s
minters93822463minter_s
minuets9259853minue_ts
miseats92815783miseats
misers85025703miser_s
misseats104011683misseats
missets94516573misse_ts
missorts1038323missorts
musers84719093muser_s
neats55931903_n_eats
nerds65719253_n_erds
nertz145117453_n_ertz
nests55728003_n_ests
nets45941533_n_e_ts
netts55320723_n_etts
newts86015283_n_ewts
niseis63512023nise_is
niters64624203niter_s
obverts1235403obverts
onset54730173onse_t_
outserts8309803outserts
pincers113916503pincer_s
pinders103720473pinder_s
pingers104020733pinger_s
pinkers134118603pinker_s
pinners93518593pinner_s
pissers95014753pisser_s
posers84223973poser_s
preinserts1243973preinserts
rasers64526783raser_s
reinsert8313213reinsert_
reseats74319583reseats
resects94115593resects
resents74221223resents
resets65427613rese_ts
resorts74817193resorts
reverts104715043reverts
ringers83922943ringer_s
rinser64317213rinser__
rinses64720383rinse__s
risers64624783riser_s
rosets65819953rose_ts
seats54844343__seats
sects75622893__sects
septs75420603__septs
seres55448893__seres
serfs84922013__serfs
sers45746653__ser_s
sets45549503__se_ts
setts55124323__setts
sexts125118383__sexts
sieverts1145713sieverts
singers83824693singer_s
sinkers113618543sinker_s
sinners74019013sinner_s
sinters74024073sinter_s
sneers64016173sneer_s
snorts64116493sn_orts
sorts54536663__sorts
sunsets72911573sunse_ts
tinders84219173tinder_s
tinkers113517143tinker_s
tinners73717303tinner_s
tinsels738373tinse_ls
tinters74221103tinter_s
twinsets1133663twinse_ts
unbelts9237663unbelts
unrests7229463unrests
unseals73212573unseals
unseams9338913unseams
unseat64221023unseat_
unsells73210773unsells
unsent63820963unsent_
unset54532433unse_t_
unsews9379363unse_ws
unsexes14248923unsexes
upsets8409683upse_ts
users55817573_user_s
verts85724733__verts
wincers123415363wincer_s
winders113721263winder_s
wingers113921473winger_s
winkers143517113winker_s
winners104316903winner_s
winters103720473winter_s
wisents10249063wisents
zingers173514843zinger_s

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.1561145455.1
2DLD Change Limit1340273557.23318529.9
3Display Results3553550.1432482.5
 (SQL Overall)1786913557.53223724.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.