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

281 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
incests9271138(None) 
incents92414531incents
incepts11238281incepts
incest82918741incest_
infests10279791infests
ingests83210981ingests
invests10319681invests
encysts1244312encysts
incants92012802incants
incases93615972incases
incenses102411002incenses
incent83320722incent_
incept102712752incept_
incises93414892incises
incrusts1036252incrusts
incuses93514852incuses
indents83114662indents
inerts64517022in_erts
infects12279712infects
infest93315432infest_
ingest73119002ingest_
ingesta8357862ingesta
injects16257452injects
inlets63915572inle_ts
inquests1744942inquests
insects93710842insects
inserts74013992inserts
insets64016132inse_ts
insists739082insists
intents72115702intents
invents102812052invents
inverts103211952inverts
invest93014842invest_
nests55728002_n_ests
nicest82315662nicest_
unrests7229462unrests
accents113511233accents
accepts13356353accepts
access1037673acces_s
accosts11107993accosts
anapests1046613anapests
ancestor1046853ancestor
ancestors1147233ancestors
ancestry1344393ancestry
ancients1098973ancients
ancress978613ancres_s
angsts738863an_gsts
arrests73312683arrests
ascents93812553ascents
asceses938623asceses
ascesis938373ascesis
attests7278813attests
behests1235953behests
bests75932613__bests
casts77237793__casts
celts75325783__celts
cents74730333__cents
cess65326053__ces_s
cesta75419483__cesta
cestas85018543__cestas
cesti75217423__cesti
cestos84718093__cestos
cestus84412913__cestus
chests114916263_chests
cineasts1045543cineasts
cists76624533__cists
conceits122813613conceits
concents122516603concents
concepts143110303concepts
concerts123016063concerts
congests113510383congests
contests103413383contests
costs77231143__costs
crests85218703_crests
cysts105912773__cysts
deceits102810883deceits
detests83711743detests
devests114410473devests
dicasts1078703dicasts
digests93610613digests
dioceses1137113dioceses
discepts1336743discepts
divests114510933divests
docents102810803docents
ecesis84611203_ecesis
egests74411253_egests
encases93116053encases
encrusts1045283encrusts
encyst1136203encyst_
enlists749393enlists
excepts1885203excepts
excess1546053exces_s
facets116316653face_ts
fests85828043__fests
finest94321733fin_est_
finless102810783finles_s
forests104114953forests
funfests14253563funfests
geests75912163_geests
gests66028813__gests
guests74311203_guests
hests85829933__hests
ices66129643i_ce__s
iciest82914743iciest_
idlest74014863idlest_
illest63615723illest_
imposts11269003imposts
imprests1246313imprests
inanest72115363inanest_
inbursts1044323inbursts
incages103013883incages
incant82418503incant_
incase83615283incas_e
incased103612393incased
incense92410303incense
incensed11277953incensed
incented112412543incented
incenter102212093incenter
incenters112510303incenters
incepted13177773incepted
inceptor1246023inceptor
inceptors1345773inceptors
incestuous1252573incestuous
inchers123912523inchers
inches114419673inc_hes
incidents1246803incidents
incipits1246263incipits
incisal947373incisal
incise83515333incis_e
incised102911583incised
incisor955323incisor
incisors1095293incisors
incite83618733inc_ite
incites93218483incites
inclasps1244353inclasps
inclips1135963inclips
incloses101610533incloses
incogs937903inc_ogs
incomes11712373incomes
increases1157383increases
increate10312203increate
incross937663incross
incrust949203incrust_
incubus1144743incubus
incudes10319523incudes
incult82414773incult_
incurs83012283inc_urs
incus73315053inc__us
incuse83513573incus_e
incused102911173incused
indenes82916253indenes
indent73021243indent_
indexes15339453indexes
indicts103210723indicts
inducts10259573inducts
indults8289493indults
inept73622153in_ept_
inert53234373in_ert_
infants102210773infants
infect113413443infect_
infers93615443infe_rs
infested12249643infested
infester11239433infester
infesters12237713infesters
inflects1336193inflects
infuses102711873infuses
ingested10259003ingested
ingots7912063in_gots
ingress838653ingres_s
inheres10315173inheres
inherits11310103inherits
inject153210233inject_
inkers104018833inke_rs
inkiest113415043inkiest_
inkless11348713inkles_s
inkpots1335173inkpots
inlet53732403inle_t_
inmesh1134863inmes_h
inmeshes1345613inmeshes
inmost8411363inmost_
inners63919353inne_rs
innless7288293innles_s
innocents1145313innocents
inputs837703in_puts
inquest1638603inquest_
inseams9307903inseams
insect83916583insect_
insert64325253insert_
inset54430863inse_t_
insist6314513insist_
inspects1255863inspects
insults7268963insults
intends8239963intends
intent63122773intent_
interests9312553interests
interns73116773interns
inters64328053inte_rs
intorts7310973intorts
intreats8311543intreats
intrusts837723intrusts
intuits7310313intuits
intwists1145593intwists
invent93316363invent_
inverses112410983inverses
invert94120083invert_
invested12229693invested
investor11247403investor
investors12227713investors
islets64513083isle_ts
jests125922453__jests
kindest12311503kindest_
kineses113111253kin_eses
kinesis11259593kin_esis
kinless113310273kinles_s
lancets93411163lance_ts
latests73910313latests
linecuts1094553linecuts
liniest73321153liniest_
linnets739833linne_ts
locusts9277933locusts
mincers113714853mince_rs
minces104420803mince__s
minciest122913103minciest_
mindsets1135683mindsets
minuets9259853minue_ts
miscasts1238343miscasts
molests93311563molests
neats55931903_n_eats
nerts55924983_n_erts
ness45526563_n_es_s
nest45548733_n_est_
nets45941533_n_e_ts
netts55320723_n_etts
newts86015283_n_ewts
nicety1138433nice_ty
noesis6311443_noesis
obtests9136233obtests
oncet74626543once_t_
onsets64013543onse_ts
oocysts1243923oocysts
pests75933273__pests
pincers113916503pince_rs
piniest93121133piniest_
pinkest132812623pinkest_
prests84021263_prests
priests93810863priests
princess12266803princes_s
quests153310353_quests
racists92613323racists
recasts93413533recasts
recepts113010263recepts
recess8314263reces_s
reests64618893_reests
reinvests1244223reinvests
renests74014213renests
rests54935873__rests
retests73813853retests
revests104413733revests
scents85317023_scents
sinless73014213sinles_s
tests56530193__tests
tincts84510803tinc__ts
tiniest73020123tiniest_
unbelts9237663unbelts
uncases93516553uncases
uncast84215713uncast_
unless62413073unles_s
unrest62918853unrest_
unseats73012853unseats
unsets64116163unse_ts
upcasts11185643upcasts
vests85325983__vests
viniest103216613viniest_
wests85727003__wests
wincers123415363wince_rs
winces114819113wince__s
winceys15395523wince_ys
winiest103419693winiest_
winless103212283winles_s
wrests95313083_wrests
zests145419743__zests

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272818.70315400.1
3Display Results2812810.0933021.5
 (SQL Overall)1786912818.95219961.0
 
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.