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

161 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
insetter821859(None) 
inserter82312131inserter
insetted9249021insetted
insetters9187131insetters
pinsetter1145011pinsetter
besetter10137982besetter
enfetter1145352enfetter
incenter102212092incenter
indenter92311442indenter
infecter13229152infecter
infester11239432infester
inputter1034202inputter
inserted92413052inserted
inserters92210282inserters
insister888782insister
insulter836882insulter
inventer112410842inventer
inverter112411072inverter
netter63722022_n_etter
pinsetters1244102pinsetters
resetter81511832resetter
setter64023722__setter
unfetter1136752unfetter
upsetter1034642upsetter
abetter958323_abetter
absenter1086773absenter
anisette846773anisette_
anisettes946673anisettes
anteater8311603anteater
assenter867703assenter
asserter877573asserter
begetter11136313begetter
besetters11136643besetters
better84723703__better
bonesetter1253183bonesetter
casette9310393casette_
casettes1039653casettes
consenter11312493consenter
deserter91211603deserter
dinette8310013din_ette_
dinettes9310193din_ettes
dissenter1059133dissenter
enfetters1244463enfetters
fetter94120383__fetter
filmsetter1551773filmsetter
fretter103412753_fretter
getter74117613__getter
imbitter12265283imbitter
incented112412543incented
incenters112510303incenters
incepted13177773incepted
inceptor1246023inceptor
inciter93113773in_citer
indebted12246873indebted
indented101811733indented
indenters102710033indenters
indentor9288513indentor
indexer15287253inde_xer
indicter1148143indicter
inditer83514233in_diter
infected14229403infected
infecters14257583infecters
infector13478853infector
inferrer11217443inferrer
infested12249643infested
infesters12237713infesters
inflater1149893inflater
ingather1244783ingather
ingested10259003ingested
injected18226753injected
injector17236933injector
inputted1134663inputted
inputters1143443inputters
insaner7310443ins_aner
insect83916583insect__
insectan1045393insectan
insectary1444213insectary
insects93710843insect_s
insecure1044653insecure
inselberg1241843inselberg
insert64325253insert__
inserts74013993insert_s
inset54430863inse_t__
insets64016133inse_t_s
insetting1079283insetting
insider849733ins_ider
insisted998673insisted
insisters997653insisters
insnarer865303insnarer
inspected1445403inspected
inspector1344753inspector
inspirer1045183inspirer
instanter946243instanter
instar6310013ins__tar
instate71616483instate_
instated91613343instated
instates81615833instates
instep838193ins__tep
instituter1044513instituter
insulted937193insulted
insulters945883insulters
insurer73312803ins_urer
integer837993inte_ger
intender93310443intender
intenser8199443intenser
inter55028493in___ter
interterm1148813interterm
invected14258883invected
invented122510663invented
inventers12269533inventers
inventor11298153inventor
inverted122312163inverted
inverters12239753inverters
invertor11238973invertor
invested12229693invested
investor11247413investor
inviter104112313in_viter
knitter11348133kn_itter
knotter11317643kn_otter
letter63722583__letter
minster93914323mins__ter
misenter10310833misenter
musette938433musette_
musettes1037433musettes
natter64420743_n_atter
neater64424313_n_eater
nester64124183_n_ester
nestler73510453_nestler
nether94014163_n_ether
netted74118713_n_etted
netters73618583_n_etters
nettier74211813_n_ettier
nettler7349503_n_ettler
neuter63713793_n_euter
nutter63918053_n_utter
petter83924773__petter
pinspotter1452123pinspotter
reletter81311023reletter
resetters9129463resetters
rosette7310373rosette_
rosettes8310343rosettes
seater64534163__seater
settee63721023__settee
setters73822063__setters
settler73410653__settler
sitter63323383__sitter
tetter64322453__tetter
unbitter1046173unbitter
unfetters1244363unfetters
unletted9310313unletted
unseated91317683unseated
unsettle866063unsettle
unsettled1055213unsettled
unsettles964653unsettles
untether1145163untether
unwetted1238123unwetted
upsetters1143653upsetters
vetter93417643__vetter
vignetter1343323vignetter
wetter93919443__wetter
whetter13348803_whetter

Search took 7 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.436409841.7
2DLD Change Limit1461621616.37622923.8
3Display Results1611610.0802012.5
 (SQL Overall)1786911616.89225927.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.