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

241 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
insects9371084(None) 
infects12279711infects
injects16257451injects
insect83916581insect_
inserts74013991inserts
insets64016131inse_ts
inspects1255861inspects
bisects1137132bisects
dissects11279242dissects
exsects1655572exsects
incents92414532incents
incepts11238282incepts
incests92711382incests
indents83114662indents
indicts103210722indicts
inducts10259572inducts
inerts64517022in_erts
infect113413442infect_
infests10279792infests
inflects1336192inflects
ingests83210982ingests
inject153210232inject_
inlets63915572inle_ts
inseams9307902inseams
insectan1045382insectan
insert64325252insert_
inset54430862inse_t_
insists739082insists
inspect1138462inspect_
insults7268962insults
intents72115702intents
invents102812052invents
inverts103211952inverts
invests10319682invests
onsets64013542onse_ts
resects94115592resects
sects75622892__sects
unseats73012852unseats
unsets64116162unse_ts
absents93510723absents
advects13276013advects
affects1535393affects
ainsells895403ainsells
analects1047703analects
aspects1146743aspects
assents74512223assents
asserts74311793asserts
assets65617663asse_ts
besets85718803bese_ts
bisect10312873bisect_
coinfects16344573coinfects
confects153110873confects
connects123010563connects
consents102715893consents
convects153410993convects
cosecs105015213cosec_s
cosets85824403cose_ts
cusecs10509153cusec_s
defects134511523defects
dejects17389223dejects
deserts82513053deserts
detects104011093detects
dialects11126003dialects
directs102710263directs
disjects18275923disjects
disseats93211503disseats
dissect103614133dissect_
dissents93411863dissents
disserts92411813disserts
effects1535283effects
ejects15409953_ejects
elects83315003_elects
enacts84012973en_acts
enserfs1035483enserfs
erects84116183_erects
expects1866883expects
exsect1558503exsect_
exserts1467013exserts
ginsengs1042653ginsengs
impacts13266503impacts
incants92012803incants
incent83320723incent_
incept102712753incept_
incest82918743incest_
incus73315053in__cus
indenes82916253indenes
indent73021243indent_
indexes15339453indexes
indices103513443indices
indict93115573indict_
induces103611813induces
induct93212743induct_
indults8289493indults
inept73622153in_ept_
inert53234373in_ert_
infants102210773infants
infarcts1345233infarcts
infected14229403infected
infecter13229153infecter
infecters14257583infecters
infector13478853infector
infectors14218553infectors
infers93615443infe_rs
infest93315433infest_
inflect1249223inflect_
inflicts1345613inflicts
infracts1346623infracts
ingest73119003ingest_
ingesta8357863ingesta
ingots7912063in_gots
inheres10315173inheres
inherits11310103inherits
injected18226753injected
injector17236933injector
injectors18216723injectors
inkers104018833inke_rs
inkpots1335173inkpots
inlaces92512903inlaces
inlet53732403inle_t_
inners63919353inne_rs
inputs837703in_puts
inquests1744943inquests
inseam8329993inse_am
insectary1444213insectary
insectile1147113insectile
insecure1044653insecure
inserted92413053inserted
inserter82312133inserter
inserters92210283inserters
insetted9249023insetted
insetter8218593insetter
insetters9187133insetters
insheath14114423insheath
insheaths15183503insheaths
insides8512653insides
insights1245493insights
insist6314513insist_
insolents9137523insolents
insoles73516243insoles
insouls737213insouls
inspans937803inspans
inspected1445403inspected
inspector1344753inspector
inspectors1444933inspectors
instals7611713instals
instants8910153instants
instars7411133instars
instate71616483instate
instates81615833instates
insteps936573insteps
instils7811453instils
instincts1144533instincts
instructs1145793instructs
insult62813673insult_
insures73117263insures
inswept1245733inswept_
intact8314663intact_
intends8239963intends
intent63122773intent_
interacts11312123interacts
intercuts1148783intercuts
interns73116773interns
inters64328053inte_rs
intersects1249153intersects
intorts7310973intorts
intreats8311543intreats
intuits7310313intuits
invected14258883invected
invent93316363invent_
invert94120083invert_
invest93014843invest_
islets64513083i_slets
isseis638563isse_is
linecuts1094553lin_ecuts
linnets739833linne_ts
linseeds944733linseeds
linseys1035083linse_ys
mindsets1135683mindse_ts
minuets9259853minue_ts
misacts1139353misacts
miseats92815783miseats
misseats104011683misseats
missets94516573misse_ts
neats55931903_n_eats
necks115119333_n_ecks
nerts55924983_n_erts
nests55728003_n_ests
nets45941533_n_e_ts
netts55320723_n_etts
newts86015283_n_ewts
nieces84112713_nieces
niseis63512023nise_is
noninsects1253663noninsects
objects18123693objects
onset54730173onse_t_
pandects1335843pandects
prosects1239473prosects
refects124012743refects
reinfects1444723reinfects
reinjects1844023reinjects
reinserts946423reinserts
reinspects1443033reinspects
rejects163910693rejects
reseats74319583reseats
resect84424703resect_
resents74221223resents
resets65427613rese_ts
respects1247703respects
rinsers73815743rinse_rs
rinses64720383rinse__s
rosets65819953rose_ts
seats54844343__seats
secs65033893__sec_s
sect67443623__sect_
selects91912143selects
septs75420603__septs
sets45549503__se_ts
setts55124323__setts
sexts125118383__sexts
snecks124410033sn_ecks
subsects12267903subsects
sunsets72911573sunse_ts
suspects1254863suspects
tincts84510803tin__cts
tinsels738373tinse_ls
transects1157823transects
trisects1035983trisects
twinsets1133663twinse_ts
unbelts9237663unbelts
unrests7229463unrests
unseals73212573unseals
unseams9338913unseams
unseat64221023unseat_
unsells73210773unsells
unsent63820963unsent_
unset54532433unse_t_
unsews9379363unse_ws
unsexes14248923unsexes
upsets8409683upse_ts
vivisects1742083vivisects
wisents10249063wisents

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.1401276364.3
2DLD Change Limit1340272417.09618887.7
3Display Results2412410.0902677.8
 (SQL Overall)1786912417.32624391.3
 
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.