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

287 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
patinae9541440(None) 
patina86022191patina_
patinaed11407831patinaed
patinas96318521patinas
patinate103016311patinate
patine85328121patin_e
carinae94318582carinae
catenae9311362catenae
laminae93512972laminae
latina65621142latina_
latinas74416462latinas
matinal9312602matinal
matinee92415612matinee
paginal10269492paginal
paginate114012442paginate
pastina93914592pastina_
pastinas103712152pastinas
patience1247512patience
patin76832852patin__
patinated123911412patinated
patinates113814692patinates
patined105114782patined
patines95225762patines
patinize19610772patinize
patins87528782patin_s
platina94413642platina_
platinas103610312platinas
ratine65131822ratin_e
retinae75517332retinae
vaginae11377682vaginae
acinar8310483_acinar
actinal9312293actinal
actiniae101810013actiniae
aline57243153_alin_e
amine75835383_amin_e
apatite9312963apati_te
atingle848253_atingle
atonal6514023_atonal
atone56527983_aton_e
azine146721413_azin_e
badinage1294923badinage
basinal9310033basinal
bastinade1244903bastinade
bating95132253batin_g
batiste939743batiste
canine83826703canin_e
cantina93417253cantina_
cantinas102713773cantinas
carina84325323carina_
carinal94318223carinal
carinas93622383carinas
carinate103320243carinate
catena8312473catena_
catenas9313103catenas
catenate10312833catenate
catkinate1545823catkinate
catnap1098383cat_nap
dating85326483datin_g
datival1135583datival
dative10311813dati_ve
detinue85010033detinue
eating75134403eatin_g
eatings84616433eatings
faciae112913413faci_ae
famine114318193famin_e
farina94618233farina_
farinas103215233farinas
fatigue1144393fatigue
fating105328673fatin_g
faunae95210373fa_unae
gamine94620153gamin_e
gating84826953gatin_g
gatings95212823gatings
gratine84719193gratin_e
gratinee93710783gratinee
hating104929713hatin_g
hepaticae16164853hepaticae
intimae9109743intimae
intine61021983intin_e
isatine7311763isatin_e
jarina134014063jarina_
jarinas143712183jarinas
katcina1345153katcina_
katcinas1434513katcinas
lacunae9116803lacunae
lamiae84817453lami_ae
lamina84920443lamina_
laminal94113633laminal
laminar93810283laminar
laminas93615873laminas
laminate103014633laminate
larine63927043larin_e
latinize17610563latinize
latino64120473latin_o
latinos73613803latinos
latrine7715123latrin_e
lawine93316463lawin_e
maline84529083malin_e
marina84623413marina_
marinade11259383marinade
marinas93519373marinas
marinate103017783marinate
marine84230403marin_e
matin75132853matin__
matinees102110423matinees
mating94832913matin_g
matings104516203matings
matins84527783matin_s
minae75627723__minae
mutine84420373mutin_e
narine63422553narin_e
national8311533national
native9613013nati_ve
opaline9412483opalin_e
pacing114522753pacin_g
padnag1036073pa_dnag
paginated13309463paginated
paginates123111363paginates
paging104020403pagin_g
pagings114411063pagings
pain65647243pa_in__
painch133511323pa_inch
pained95622853pa_ined
pains75138283pa_in_s
paint75443693pa_in_t
painted104214633pa_inted
painter93814563pa_inter
paints85921833pa_ints
painty114714753pa_inty
paisa76021073pa_isa_
paisan84417073pa_isan
paisas84317493pa_isas
paise75028333pa_i_se
palatinate1245593palatinate
palatine10316063palatin_e
paleae84820293pa_leae
palikar1335453palikar
paling93530133palin_g
palings103915823palings
palinode1145713palinode
palisade1145833palisade
pane64950283pa__n_e
panicle11129983panicle
panini8314273panin_i
panino8315683panin_o
panne76623653pa__nne
pantie84326473panti__e
pantile93918483panti_le
panting104025423pantin_g
papillae12137013papillae
papulae11249353papulae
parae76335703pa__rae
pardine103616723pardin_e
pariah114320583pari_ah
parian83223963pari_an
parians93519733parians
paring94236493parin_g
parings104219213parings
partial92616263parti_al
partible1238063partible
particle1239533particle
parting103527383partin_g
partings113513733partings
partisan1058423partisan
partita9310863partita_
partitas10310253partitas
partite9317133parti_te
partizan1955643partizan
pastiche1546933pastiche
pastie85525523pasti__e
pastille1038943pastille
pastime114611973pasti_me
pasting103826553pastin_g
pataca10311193pataca_
patacas11311003patacas
patamar1147093patamar
pate65350463pat___e
patellae1047623patellae
paten74827343paten__
patency1466313patency
patens84820863paten_s
patent84524923paten_t
patented1188893patented
patentee1099943patentee
patents94815203patents
paternal1038333paternal
pathway1844853pathway
patiences1367433patiences
patient9617073patient
patienter1145553patienter
patients1088763patients
patining11312303patining
patinized2178813patinized
patinizes20710333patinizes
patio74426353pati__o
patios85221783pati_os
patriate10311933patriate
patronage1264823patronage
patronal1048653patronal
pattee84323383pat_tee
pattie84020963pat_tie
patting103722343pattin_g
pavane114113443pavan_e
pavin105623203pavin__
paving124519743pavin_g
pavings134011633pavings
pavins114919663pavin_s
pavise114714803pavi_se
pavisse12546813pavisse
pawing124519553pawin_g
pawnage1335873pa_wnage
pawnee113115403pa_wnee
paying123722163payin_g
pectinate1349553pectinate
pennae84314033p_ennae
perinea9313033perinea
petiole9311303petiole
petite84320653peti_te
petnap1037423pet_nap
pina65842633p__ina_
pinas75434453p__inas
pine67755713p__in_e
pinnae84414643p_innae
piscinae1285213piscinae
platane93112303platan_e
plating103823073platin_g
platings113611363platings
platinic1237073platinic
platinize2068103platinize
platinum1245443platinum
plicae10410953p_licae
pointe84619313p_ointe
pontine92419053pontin_e
potence11711363potence
potiche1438043potiche
potline91015233potlin_e
poutine93316823poutin_e
praline93019743pralin_e
prating103424453pratin_g
pratique19134283pratique
prince104114763p_rince
ptisan8417973p_tisan
purine85321893purin_e
rapine85023083rapin_e
ratines75328583ratines
rating74938703ratin_g
ratings84217403ratings
rational8412543rational
rationale949463rationale
ratite65022423rati_te
ratline74517803ratlin_e
ravine95522223ravin_e
reginae84713453reginae
retina65023383retina_
retinal75318353retinal
retinas74819353retinas
retine66237333retin_e
retinue75414843retinue
sabine84020393sabin_e
salina64221123salina_
salinas73116093salinas
saline65132703salin_e
saltine75018563saltin_e
sarcinae1047193sarcinae
satiate7315403satiate
satin55935213satin__
satinet7325283satinet
sating74735453satin_g
satins64930483satin_s
satiny93817983satin_y
satire63218003sati_re
savine94220283savin_e
spartina1037983spartina_
spartinas1135793spartinas
spatial9310323spati_al
taeniae739083taeniae
tine45855133__tin_e
tinea54923153__tinea
tinge64626613__tinge
vagina102710933vagina_
vaginal11288403vaginal
vaginas11298813vaginas
vaginate123911083vaginate
vahine123612113vahin_e
valine94623093valin_e
vatical1239983vatical
wahine123813013wahin_e

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.1531167915.0
2DLD Change Limit1340272877.11018850.5
3Display Results2872870.1102609.1
 (SQL Overall)1786912877.37324235.9
 
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.