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

419 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
fritzes1932945(None) 
friezes19418911friezes
frites94922481frit_es
frizes184015461fri_zes
frizzes18338181frizzes
ritzes154812941_ritzes
blitzes18408702blitzes
ditzes163212422_ditzes
ferities111416712ferities
fizzes174512552f_izzes
flites95122442flit_es
freezes193310352freezes
fridges12369482fridges
fries85535602fri__es
frieze18378142frieze_
friges104116482fri_ges
fringes113514102fringes
frisees104411692frisees
frises94124272fri_ses
friths124313582frit_hs
frits86129102frit__s
fritted113611332fritted
fritter103912772fritter
fritters113810782fritters
fritts94613192frit_ts
fritz176020772fritz__
frized193510682fri_zed
frizer184011282fri_zer
frizers19329552fri_zers
frizzed19375972frizzed
frizzer18446892frizzer
frizzers19335102frizzers
frizzies19315932frizzies
frizzles19297282frizzles
futzes184313112f_utzes
glitzes17367562glitzes
prizes173819812pri_zes
rites54442552_rit_es
spitzes1849172spitzes
spritzes1946932spritzes
writes94420332writ_es
writhes134811702writhes
afrits9311903afrit__s
amities9317383amities
aretes64425353aret_es
ariettes8411353ariettes
arises65233803ari_ses
axites134913833axit_es
baizes174315053bai_zes
barites94322333barit_es
bites75641173_bit_es
bizes165923663_bi_zes
bizzes163910843_bizzes
blintzes1944263blintzes
blites84721213blit_es
blitzed19336533blitzed
blitzer18447663blitzer
blitzers19417153blitzers
boites84322703boit_es
bortzes1838223bortzes
braizes183112453braizes
brazes175522193br_azes
breezes18318693breezes
bribees11409283bribees
bribes105918533bri_bes
brides94423513bri_des
bridges113911333bridges
bridles104114473bridles
bries74942153bri__es
brines85028853bri_nes
brinies93317913brinies
brises84927613bri_ses
brisses94314313brisses
bristles101510433bristles
britches15278683britches
briths115113863brit_hs
brits76433083brit__s
brittles10178653brittles
britts84813443brit_ts
britzka22132133britzka
britzkas23132053britzkas
bronzes183510403bronzes
brutes86118683brut_es
cerites94823433cerit_es
chintzes2235963chintzes
cites74435583_cit_es
cities84524853_cities
crates85736053crat_es
crazes174720133cr_azes
cries75438403cri__es
crimes105521583cri_mes
cringes103215503cringes
cripes105120873cri_pes
crises84529433cri_ses
critics112811093critics
crits75527573crit__s
critter94113033critter
critters103511313critters
crozes174417663cr_ozes
curites93919863curit_es
deities82621923deities
dirties83119383dirties
dites66339153_dit_es
dries64733673dri__es
drives105117113dri_ves
drizzles17295293drizzles
elites66027123elit_es
erotizes17311213erotizes
ersatzes1743063ersatzes
evites94916473evit_es
failles102914123failles
fairies103516043fairies
faithed1437163faithed
faiths124610273fait_hs
fates85139233f_at_es
fatties103018203fatties
fazes175527213f__azes
feazes184514173f_eazes
feezes184412613f_eezes
ferrites112312823ferrit_es
fetes85630143f_et_es
fettles103912733fettles
fezes175220023f__ezes
fezzes174910403f_ezzes
fibres114312123f_ibres
fices106031163f_i_ces
fiches145219533f_iches
ficoes114613463f_icoes
fidges114114383f_idges
fifes114822393f_i_fes
fifties132111083fifties
files85441273f_i_les
filles94224523f_illes
fines86644263f_i_nes
finites10315923finit_es
fiques1837973f_iques
fires85740753f_i_res
firths125113503firt_hs
fishes125221343f_ishes
fitches153516193f_itches
fitness10299393f_itness
fits76043463f_it__s
fitted104716663f_itted
fitter94120033f_itter
fitters104517743f_itters
fittest102510803f_ittest
fives116027363f_i_ves
fixes154723593f_i_xes
fixities1838213fixities
fizzed18369443f_izzed
fizzer17369383f_izzer
fizzers18357003f_izzers
fizzles18339063f_izzles
flies85630713fli__es
flitches16388463flitches
flite85424963flit_e_
flited104616583flit_ed
flits85625223flit__s
flitted114011643flitted
flitter103413903flitter
flitters114312173flitters
flutes95421783flut_es
flytes123911563flyt_es
foibles1238853foibles
fomites123613203fomit_es
footies103721543footies
footles103715713footles
fortes95327183fort_es
forties104323863forties
frailties1245853frailties
fraises104215693fraises
frames115119863fr_ames
frappes14328383frappes
frasses104314513frasses
frater94520593frat_er
fraters103517203fraters
frats86829673frat__s
frazzles19284813frazzles
frees86131393fr__ees
freeze18349513freeze_
freezer19348523freezer
freezers20307173freezers
frenzies2037713frenzies
freres94716173fr_eres
freshes133515823freshes
fretless1138063fretless
frets85523403fret__s
fretted113411853fretted
fretter103412753fretter
fretters113410303fretters
friaries11310083friaries
friars93812093fri_ars
fribbles15287713fribbles
fridge11379253fridge_
fried95322913fri__ed
friends11396743friends
frier85225843fri__er
friers94718933fri_ers
frigates12310923frigates
frigged13439053frigged
frights14339623frights
frigs96019273fri__gs
frijoles1834373frijoles
frilled113911603frilled
friller104111743friller
frillers11349863frillers
frills94414223fri_lls
fringe104013953fringe_
fringed123611523fringed
frisbee12298513frisbee
frisbees13295013frisbees
frise85322453fri_se_
frisee94217993fri_see
frisettes1295353frisettes
frisked15478823frisked
frisker14389273frisker
friskers15337373friskers
frisket143811773frisket
friskets15326263friskets
frisks13479263fri_sks
frit77044473frit___
frith115922033frit__h
fritt86129413frit__t
frivols1334743frivols
friz166324343fri_z__
frizettes2193493frizettes
frizz165512623fri_z_z
frizzier19284813frizzier
frizziest20294143frizziest
frizzle18367043frizzle
frizzled20325703frizzled
frizzler19345843frizzler
frizzlers20293673frizzlers
frizzly21455793frizzly
frizzy20555833fri_zzy
froes86126693fr__oes
frontes104214163frontes
frothed14288783frothed
frother133110153frother
frothers14279803frothers
froths125411443frot_hs
froze174515653fr_oze_
frozen18408443fr_ozen
fruitages1344483fruitages
fruited11389093fruit_ed
fruiter10309683fruit_er
fruiters11328173fruiters
fruitier1136583fruitier
fruitiest1237383fruitiest
fruitless1244163fruitless
fruitlet1146883fruitlet
fruitlets1243173fruitlets
fruits94512493fruit__s
furies95126373furi__es
furmities1447523furmities
furzes186613693f_urzes
futzed19418983f_utzed
fuzes175120223f__uzes
fuzzes175412253f_uzzes
fyttes1236933f_yttes
gites65630183_git_es
glitzed18375493glitzed
goitres8389563goitres
grates75429883grat_es
grazes164519643gr_azes
grides84422363gri_des
grieves1137323grieves
griffes14367923griffes
grilles83715023grilles
grilses8319153grilses
grimes94619033gri_mes
gripes94619873gri_pes
grippes124810373grippes
gristles9189203gristles
griths105211653grit_hs
grits65529583grit__s
gritted94110903gritted
gritter83913353gritter
gritters94210633gritters
grizzles17286193grizzles
hertzes1938293hertzes
irides74519123iri_des
irises64221173iri_ses
iritis63113733irit_is
iritises839973iritises
kibitzes2342863kibitzes
kirtles11309663kirtles
kites95432543_kit_es
kithes135016653_kithes
klutzes2064113klutzes
krises105016083kri_ses
laities7320343laities
litres65220393_litres
lutzes153711923_lutzes
maizes175115733mai_zes
mites75141803_mit_es
mitres83922073_mitres
nites55736343_nit_es
nitres65519333_nitres
norites74018803norit_es
orates64328613orat_es
orioles7412993orioles
ornithes1136423ornithes
parities10522973parities
phizes20389133phi_zes
pities83828083_pities
plotzes18317693plotzes
prates84633163prat_es
pretzel1835143pretzel
pretzels1934033pretzels
prezes173614693pr_ezes
prices104524543pri_ces
prides94324183pri_des
pries74339533pri__es
primes104225263pri_mes
princes113015143princes
prises84133173pri_ses
prisses94816713prisses
prithee1239933prithee
privies122414263privies
prize164718943pri_ze_
prized184415393pri_zed
prizer174714883pri_zer
prizers183911843pri_zers
purities10316283purities
putzes174212523_putzes
pyrites12812203pyrit_es
quizzes2435573quizzes
rarities8316333rarities
rates55352013_rat_es
razes145032703_r_azes
razzes144910063_razzes
reties65436193_reties
ribes75530173_ri_bes
rices75536153_ri_ces
riches115022083_riches
rides66140813_ri_des
ridges85817003_ridges
rifles94217703_rifles
riles55343643_ri_les
rilles64725503_rilles
rimes75634543_ri_mes
rinses64720383_rinses
ripes75435773_ri_pes
rises55244043_ri_ses
rite45849453_rit_e_
ritter63822413_ritter
ritters74020613_ritters
ritz135129983_ritz__
ritzier16297203_ritzier
ritziest17237843_ritziest
ritzy175611163_ritz_y
rives85336003_ri_ves
rotes56143903_rot_es
rottes64524833_rottes
seizes154317533sei_zes
sites56045433_sit_es
sizes146727763_si_zes
skites104418033skit_es
smites83921923smit_es
sorites73825243sorit_es
spites84127333spit_es
sprites94220333sprit_es
spritzed2044783spritzed
spritzer1944553spritzer
spritzers2043903spritzers
suites63727403suit_es
tithes94720213_tithes
titles63719923_titles
titres64718933_titres
triages82613793triages
tribes85119023tri_bes
trices84826333tri_ces
trienes74118413trienes
tries55742813tri__es
trifles103814823trifles
trikes105419493tri_kes
trines64132563tri_nes
triodes84012503triodes
trioses75015653trioses
tripes85324873tri_pes
triples94616873triples
trite54730033trit_e_
triter65120593trit_er
tritest7315273trit_est
tritones83413443tritones
tritons73814883tritons
triunes74311383triunes
tzetzes1532673tzetzes
tzitzis1542413tzitzis
unites65024853unit_es
unities72520143unities
unitizes1739133unitizes
urates65027763urat_es
urines64724123uri_nes
verites103822253verit_es
verities111418043verities
virtues10338023virtues
waltzes1935953waltzes
whites123919883whit_es
whities133113253whities
whizzes2134713whizzes
winzes184313053_winzes
wites85536963_wit_es
withes124620843_withes
wizes174723343_wi_zes
wizzes175110773_wizzes
wries85827743wri__es
write85522833writ_e_
writer94416513writ_er
writers105513493writers
writhe125310703writhe_
writhed14389623writhed
writhen13407863writhen
writher134010853writher
writhers14398983writhers
writs86624383writ__s
written10336343written
yutzes18408413_yutzes

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.1561145455.1
2DLD Change Limit1340274197.06318975.9
3Display Results4194190.1532738.6
 (SQL Overall)1786914197.37224239.1
 
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.