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

276 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
ingests8321098(None) 
incests92711381incests
infests10279791infests
ingest73119001ingest_
ingesta8357861ingesta
invests10319681invests
angsts738862ang_sts
congests113510382congests
digests93610612digests
egests74411252_egests
gests66028812__gests
incents92414532incents
incepts11238282incepts
incest82918742incest_
indents83114662indents
inerts64517022in_erts
infects12279712infects
infest93315432infest_
ingested10259002ingested
ingots7912062ing_ots
ingress838652ingres_s
injects16257452injects
inlets63915572inle_ts
inquests1744942inquests
insects93710842insects
inserts74013992inserts
insets64016132inse_ts
insists739082insists
intents72115702intents
invents102812052invents
inverts103211952inverts
invest93014842invest_
nests55728002_n_ests
unrests7229462unrests
ageists848493_ageists
agents74816293_agents
agists75713173_agists
anapests1046613anapests
angels74416173ange_ls
angelus8418463angelus
angers75222543ange_rs
angst6415493ang_st_
argents84014853argents
arrests73312683arrests
attests7278813attests
begets96215523bege_ts
behests1235953behests
bests75932613__bests
biggest1138143biggest_
bigness1038193bignes_s
bingers104519983binge_rs
binges93923123binge__s
chests114916263_chests
cineasts1045543cineasts
congest104618773congest_
contests103413383contests
crests85218703_crests
degusts936063degusts
detests83711743detests
devests114410473devests
digest84019623digest_
dingbats1245003dingbats
dingers94321373dinge_rs
dinges83825423dinge__s
dingeys12458403dinge_ys
dingiest102915363dingiest_
dinguses1037633dinguses
disgusts1045643disgusts
divests114510933divests
egest65222343_egest_
egesta7428653_egesta
encysts1244313encysts
engluts834533engluts
enlists749393enlists
fests85828043__fests
fidgets12388763fidge_ts
finest94321733fin_est_
fingers113418423finge_rs
finless102810783finles_s
forests104114953forests
funfests14253563funfests
gasts66628633__gasts
geests75912163_geests
gelts65924613__gelts
gents65729613__gents
gest56149133__gest_
geste65920693__geste
gestes75721393__gestes
gets55442483__ge_ts
gingelis10247083gingelis
gingers94118633ginge_rs
gists66026193__gists
guests74311203_guests
gusts65722793__gusts
hangnests1344543hangnests
hests85829933__hests
hingers113420193hinge_rs
hinges105121023hinge__s
hugest10311763hugest_
hygeists1543543hygeists
iciest82914743iciest_
idlest74014863idlest_
igneous835773igneous
illest63615723illest_
imagists1175113imagists
imposts11269003imposts
imprests1246313imprests
inanest72115363inanest_
inbursts1044323inbursts
incants92012803incants
incases93615973incases
incenses102411003incenses
incent83320723incent_
incept102712753incept_
incises93414893incises
incrusts1036253incrusts
incuses93514853incuses
indenes82916253indenes
indent73021243indent_
indexes15339453indexes
indicts103210723indicts
indigents11208273indigents
inducts10259573inducts
indults8289493indults
inept73622153in_ept_
inert53234373in_ert_
infants102210773infants
infect113413443infect_
infers93615443infe_rs
infested12249643infested
infester11239433infester
infesters12237703infesters
inflects1336193inflects
infuses102711873infuses
ingate73018233ing_ate
ingates82716893ingates
ingenue847123ingenue
ingenues947093ingenues
ingesting11129623ingesting
ingestion10137483ingestion
ingestions1197593ingestions
ingestive1347393ingestive
ingles74420873ing_les
ingot61221063ing_ot_
ingrafts12105793ingrafts
ingrate8715113ingrate
ingrates9514153ingrates
ingresses1038533ingresses
ingulfs1134733ingulfs
inheres10315173inheres
inherits11310103inherits
inject153210233inject_
inkers104018833inke_rs
inkiest113415043inkiest_
inkless11348713inkles_s
inkpots1335173inkpots
inlet53732403inle_t_
inmesh1134853inmes_h
inmeshes1345613inmeshes
inmost8411363inmost_
inners63919343inne_rs
innless7288293innles_s
inputs837703in_puts
inquest1638603inquest_
inseams9307903inseams
insect83916583insect_
insert64325253insert_
inset54430863inse_t_
insist6314503insist_
inspects1255863inspects
insults7268963insults
intends8239963intends
intent63122773intent_
interests9312553interests
interns73116763interns
inters64328043inte_rs
intorts7310963intorts
intreats8311543intreats
intrusts837723intrusts
intuits7310313intuits
intwists1145593intwists
invent93316363invent_
inverses112410983inverses
invert94120083invert_
invested12229693invested
investor11247393investor
investors12227693investors
islets64513083isle_ts
jests125922453__jests
jingoists17113763jingoists
kindest12311503kindest_
kineses113111253kin_eses
kinesis11259593kin_esis
kingless13288693kingles_s
kinglets13318583kinglets
kingposts1642803kingposts
kinless113310273kinles_s
latests73910313latests
legists899593legists
lingers84223293linge_rs
lingiest93715243lingiest_
linguists1045743linguists
liniest73321153liniest_
linnets739823linne_ts
longest84114953longest_
midgets113910253midge_ts
mindsets1135683mindsets
mingiest113315813mingiest_
minuets9259853minue_ts
molests93311563molests
neats55931903_n_eats
nerts55924983_n_erts
ness45526563_n_es_s
nest45548733_n_est_
nets45941533_n_e_ts
netts55320723_n_etts
newts86015283_n_ewts
nicest82315663nicest_
nidgets9358143nidge_ts
nighest11310693nighest_
nights104117723nig_hts
noesis6311443_noesis
nonguests1044393nonguests
obtests9136233obtests
onsets64013543onse_ts
orgeats838353orgeats
pests75933273__pests
pingers104020733pinge_rs
piniest93121133piniest_
pinkest132812623pinkest_
prests84021263_prests
priests93810863priests
quests153310353_quests
reests64618893_reests
regents83416543regents
reinvests1244223reinvests
renests74014213renests
rests54935873__rests
retests73813853retests
revests104413733revests
ringent8315153ringent_
ringers83922943ringe_rs
ringgits1044193ringgits
ringlets92910233ringlets
sagest74920263sagest_
signets83311503signe_ts
singers83824693singe_rs
singes74326853singe__s
singlets93611473singlets
sinless73014213sinles_s
songfests1342983songfests
suggests1044713suggests
tangents938713tangents
tests56530193__tests
tinges74722323tinge__s
tiniest73020123tiniest_
unbelts9237663unbelts
unguents945153unguents
unless62413073unles_s
unrest62918853unrest_
unseats73012853unseats
unsets64116163unse_ts
vests85325983__vests
viniest103216613viniest_
wests85727003__wests
widgets12318453widge_ts
wingers113921473winge_rs
wingiest123214273wingiest_
wingless122910023wingles_s
winglets12299593winglets
winiest103419693winiest_
winless103212283winles_s
wrests95313083_wrests
zests145419743__zests
zingers173514843zinge_rs
zingiest182810883zingiest_

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 Filter1786911340270.1601116818.8
2DLD Change Limit1340272766.64020184.8
3Display Results2762760.1102509.1
 (SQL Overall)1786912766.91025859.8
 
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.