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

237 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
pizza1538181pizza
dizzy177410852dizzy
fizz157519822fizz_
fizzy199015082fizzy
piazza1643822piazza
piazze1634682piazze
pizazz1554222pizazz
pizzas1646982pizzas
pizzaz1565442pizzaz
pizzle16279492pizzle
tizzy16548892tizzy
bib77045933bi__b
bibb75819203bi_bb
biz147939353bi_z_
bize155926283bi_ze
bizes165923663bizes
bizzes163910843bizzes
buzz146617803buzz_
diazo15310033diazo
dib65746933di__b
ditz146929513ditz_
ditzy186513283ditzy
dizen155214933dizen
epizoa1745013epizoa
fezzy199811453fezzy
fib86344263fi__b
fiz156238763fi_z_
fizzed18369443fizzed
fizzer17369383fizzer
fizzes174512553fizzes
fizzle17369713fizzle
frizz165512623frizz_
frizzy20555833frizzy
fuzz158420573fuzz_
fuzzy1929814513fuzzy
gib66443523gi__b
ginzo1539613ginzo
gizmo1756013gizmo
hijab1736803hijab
huzza1646093huzza
iamb86623723_iamb
izar136616013_izar
jazz193714463jazz_
jazzbo2342713jazzbo
jazzy23396363jazzy
jib125835963ji__b
jibb155816733ji_bb
lezzy16608083lezzy
lib57750263li__b
limb85429373li_mb
mezzo1537433mezzo
mib76946113mi__b
mirza16410443mirza
mizen164815273mizen
mizzen16447953mizzen
mizzle16279993mizzle
mizzly19256103mizzly
muzzy188410603muzzy
nib56745183ni__b
nizam16310253nizam
pazazz1554023pazazz
phiz186718843phiz_
phizes20389133phizes
pi48145363pi___
pia56848033pi__a
pial65636703pi_al
pian66136093pi_an
piano76118713piano
pians75126963pians
pias66542553pi_as
piazzas1743643piazzas
pibal95217323pibal
pic76046823pi__c
pica85831493pi_ca
pical95524373pical
picas94626523picas
pice84641093pi_ce
pick125933813pi_ck
picks135226143picks
picky165416943picky
picot95031013picot
pics85633913pi_cs
picul95015363picul
pie55457403pi__e
piece96717993piece
pied75035363pi_ed
pier66035293pi_er
piers75926333piers
pies66949603pi_es
pieta75421753pieta
piety105817303piety
pig65744973pi__g
piggy124011433piggy
pigmy13299433pigmy
pigs76634223pi_gs
piing85218833piing
pika106322953pi_ka
pikas114218093pikas
pike106335213pi_ke
piked125623313piked
piker115622843piker
pikes115031033pikes
piki106520563pi_ki
pikis115116393pikis
pilaf103923483pilaf
pilar75221503pilar
pilau73618523pilau
pilaw103913743pilaw
pile65649693pi_le
pilea75123953pilea
piled85232993piled
pilei74021783pilei
piles74742613piles
pili66130353pi_li
pilis75825203pilis
pill65339463pi_ll
pills74130973pills
pilot77435063pilot
pilus75921063pilus
pily96132733pi_ly
pima85428653pi_ma
pimas94725103pimas
pimp106024903pi_mp
pimps114616983pimps
pin57066723pi__n
pina65842633pi_na
pinas75434453pinas
pinch125619303pinch
pine67755713pi_ne
pined85935323pined
pines76048863pines
piney105727503piney
ping75943593pi_ng
pingo87122713pingo
pings85830883pings
pink107039383pi_nk
pinko115618253pinko
pinks115729383pinks
pinky145823403pinky
pinna75320183pinna
pinny105222063pinny
pinon76024533pinon
pinot78737293pinot
pins65558453pi_ns
pint66963173pi_nt
pinta75727053pinta
pinto75625753pinto
pints75936223pints
pinup9612883pinup
piny911838353pi_ny
pion67235293pi_on
pions75826393pions
pious74621273pious
pip78051043pi__p
pipal95118353pipal
pipe86434433pi_pe
piped105123163piped
piper96523193piper
pipes96030143pipes
pipet95533323pipet
pipit95224873pipit
pips85837133pi_ps
pipy115421513pi_py
pique16410173pique
pirn67128373pi_rn
pirns76020093pirns
pirog83913673pirog
pis56362033pi__s
pisco96314983pisco
pish96127913pi_sh
piso66727563pi_so
pisos76021063pisos
piss65033333pi_ss
piste75824603piste
pit56471923pi__t
pita65436433pi_ta
pitas77427673pitas
pitch125018413pitch
pith95432693pi_th
piths105817543piths
pithy135614463pithy
piton76121583piton
pits66348743pi_ts
pitta75018693pitta
pity96031933pi_ty
piu56639543pi__u
pivot106523873pivot
pix126437933pi__x
pixel143911903pixel
pixes144323173pixes
pixie145415523pixie
pixy166117763pi_xy
pizazzy1952243pizazzy
pizzazz0243023pizzazz
pizzles17329273pizzles
plaza164311063plaza
pleb86123813p_leb
plumb114514073plumb
prez156126313prez_
prize164718943prize
prized184415393prized
prizer174714883prizer
prizes173819813prizes
pub76037693p__ub
putz158326323putz_
puzzle16318603puzzle
razz125219423razz_
rib56848023ri__b
ritz135129983ritz_
ritzy175611163ritzy
sib56850303si__b
sibb85921413si_bb
sizar145214993sizar
size135630963si_ze
sized155519243sized
sizer145521813sizer
sizes146727763sizes
sizy164816393si_zy
sizzle14309613sizzle
spazz155811133spazz_
spitz166017963spitz_
tazza1338083tazza
tazze1339573tazze
vizir17359393vizir
vizor173010093vizor
whizz194210323whizz_
whizzy23274073whizzy
winze175014853winze
wiz156434153wi_z_
wizen175813863wizen
wizes174723343wizes
wizzen17387203wizzen
wizzes175110773wizzes
zineb165614143zineb
zizit13313273zizit
zizzle13247313zizzle
zzz1017911913__zzz

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836672374.15620131.6
3Display Results2372370.0633761.9
 (SQL Overall)1786912374.32941277.7
 
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.