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

223 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
poorish12371230(None) 
boorish123712591boorish
moorish123311781moorish
pooris83916841pooris_
boarish123911912boarish
boobish14338942boobish
bookish163610022bookish
coolish12312522coolish
foolish1339612foolish
goodish1237962goodish
moonish123311042moonish
noirish1037882noirish
nourish1039702nourish
ogrish1039262_ogrish
parish115022352p_arish
perish114619062p_erish
polish114916722p_olish
poorest9312772poorest
poori74816232poori__
poortith1355362poortith
popish133812112p_opish
porism104518062p_orism
sourish10310692sourish
spookish1744642spookish
whorish1636602whorish
abolish12311503abolish
actorish1349433actorish
amorist9317643amorist
aorist64827873_aorist
aphorise1339983aphorise
aphorism1548643aphorism
aphorist13412503aphorist
bearish123013273bearish
boarfish1635753boarfish
boggish14238653boggish
boorishly1743633boorishly
boors74325013boor_s_
boxfish2285543boxfish
boyish142911233_boyish
ceorlish1345383ceorlish
cherish15310463cherish
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
colorism122112433colorism
colorist102818993colorist
coltish121310933coltish
cowfish1836433cowfish
coyish143710393_coyish
cronish12310863cronish
currish1238353currish
dogfish15226763dogfish
doggish13237533doggish
dollish11610093dollish
doltish11118733doltish
donnish11187633donnish
doors65022133door_s_
dovish1338103_dovish
dronish1138913dronish
fairish1338993fairish
florist10314243florist
flourish1446753flourish
fogyish1735363fogyish
folkish1736563folkish
foolfish1744393foolfish
foppish1735103foppish
foxfish2354483foxfish
garish104516923_garish
gnomish1345563gnomish
goatish1139563goatish
goyish13379013_goyish
hogfish17257023hogfish
hoggish15247593hoggish
hoorah124411113hoor_ah
hoorahs13399603hoorahs
hottish13117893hottish
houris94514563houris_
loggish12258723loggish
longish11229093longish
lookism1335913lookism
lookist1139563lookist
loris55329153_loris_
loudish1137983loudish
loutish1039963loutish
lowish12310533_lowish
marish114319053_marish
mobbish1635923mobbish
modish123813543_modish
monish114217593_monish
monkish1638243monkish
moonfish1675333moonfish
moonrise1046783moonrise
moorier93113073moorier
mooriest102812723mooriest
mooring102514443mooring
moors74923143moor_s_
mopish134311593_mopish
morris83814723morris_
motorise10311523motorise
motorist10314413motorist
noris54928273_noris_
oafish121311723_oafish
oarfish13158613_oarfish
oddish11107653_oddish
offish15137273_offish
ogreish1134673_ogreish
ogrism937913_ogrism
oldish10169313_oldish
onrush935343_onrush
oolith93813243_oolith
oorie53026363_oori_e
orisha936773__orisha
orris54516553_orris_
owlish1238693_owlish
palish114718273p_alish
panfish15229973panfish
pariah114320583p_ariah
paris75145943p_aris_
peakish16268873peakish
peckish18227293peckish
peevish1535783peevish
peonism11611103peonism
peris75537073p_eris_
perkish16258823perkish
pettish1238283pettish
phoresy1534653phoresy
pigfish16217173pigfish
piggish14227703piggish
pinfish15319303pinfish
pinkish16279113pinkish
pish96127913p___ish
pixyish2253653pixyish
planish12412053planish
plenish1239943plenish
poetise9314043poetise
pois66539043p_o_is_
poise75127893p_o_ise
poisha1135723p_o_isha
polarise10513903polarise
poleis86018353poleis_
polis74731163p_olis_
pollist9816603pollist
poloist91016323poloist
pooch124815303poo__ch
poods85124753poo_ds_
poofs105222793poo_fs_
pooftah1543143pooftah
pooh96027383poo___h
poohing133112323poohing
poohs103915713poo_hs_
pooing93820683poo_ing
pooling103219093pooling
pools74427703poo_ls_
poons75430973poo_ns_
pooping123615443pooping
poops94422413poo_ps_
poor65630223poor___
poorer82613993poor_er
poorly1137893poor_ly
poorness1036353poorness
poortiths1442723poortiths
poos65949113poo__s_
pooves113914713pooves_
porch125918623p_or_ch
pores75849033p_ores_
poring94227273p_oring
porisms113713453p_orisms
porks115124143p_orks_
porns75527343p_orns_
porose84818743p_orose
porous84419483porous_
ports75934593p_orts_
posh95427323p_o__sh
potash1138273p_otash
pouring103115863pouring
pours74623183pour_s_
prise74632613p__rise
prism94820263p__rism
priss74623893p__riss
promise113415843promise
protist9320223protist
proviso1237313proviso
prudish1376563prudish
ptosis83611823ptosis_
publish1447913publish
puckish18237213puckish
puggish14265993puggish
punish111411503p_unish
punkish16257693punkish
pupfish1735533pupfish
puris75332023p_uris_
purism104715063p_urism
purist85525053p_urist
pyosis114012123pyosis_
roguish1156833roguish
rompish1436693rompish
shortish1437413shortish
slowish1337633slowish
softish13127813softish
sottish10129433sottish
spooring113111463spooring
spoors84014023spoor_s_
stonish10410653stonish
tigrish1137563tigrish
toadish1139063toadish
tonish93415903_tonish
tonnish10149093tonnish
tourism939423tourism
tourist7313203tourist
tovarish1445123tovarish
townish13167933townish
toyish122911123_toyish
tsooris734693tsooris_
tsoris63411193tsoris_
vaporish16246733vaporish
vigorish1545173vigorish
voguish1465203voguish
wearish132310153wearish
woggish15276673woggish
wolfish1636933wolfish
woosh113710733woo__sh
wormish1537163wormish
zoris145320013_zoris_

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 Limit1340272237.61017612.0
3Display Results2232230.0762934.2
 (SQL Overall)1786912237.84222786.4
 
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.