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

248 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
larkish143908(None) 
darkish1537941darkish
largish1138601largish
blackish1976712blackish
carlish12312762carlish
clerkish1744262clerkish
garfish14179202garfish
garish104516922gar_ish
garnish111610842garnish
gawkish1835832gawkish
hawkish2036552hawkish
laddish12299722laddish
ladyish14287822ladyish
laris54737462lar_is_
larkier113711522larkier
larkiest123713312larkiest
larking123718252larking
larks95227812lark_s_
latish92416172la_tish
lavish124112982la_vish
lazyish22265852lazyish
marish114319052mar_ish
mawkish1935822mawkish
oarfish13158612oarfish
parish115022352par_ish
perkish16258822perkish
rakish134313962ra_kish
rankish14510382rankish
sparkish17276972sparkish
tarnish101611872tarnish
tartish101512632tartish
varnish13169532varnish
warmish1538372warmish
aguish1059283_aguish
alarmism1245853alarmism
alarmist1049123alarmist
ankush13114433_ankush
apish105116633_a_pish
arise56436433_ar_ise
arkose104911343_arkose
arks85936873_ark_s_
arris56824683_arris_
arsis55722423_arsis_
artist64125543_artist
aspish114810333_aspish
babyish1736513babyish
bairnish1345473bairnish
baldish1339503baldish
banish111416043ba_nish
barkier133814483barkier
barkiest144115153barkiest
barking144724183barking
barks115735813bark_s_
batfish1558683batfish
bearish123013273bear_ish
blackfish2343833blackfish
blandish1497003blandish
bleakish1745053bleakish
blockish19115793blockish
boarfish1635753boarfish
boarish123911913boar_ish
bookish163610023bookish
brackish1987613brackish
buckish18237883buckish
burnish1238623burnish
caddish143810123caddish
carking144322853carking
carks115534213cark_s_
carwash1535993carwash
catfish1559023catfish
cattish12410723cattish
clannish1345263clannish
clarkia1334873clarki_a
clarkias1444793clarkias
clayish1547943cla_yish
cockish1838503cockish
crankish1736513crankish
currish1238353currish
dampish1567663dampish
danish101513793da_nish
darkest122512623darkest
darkie113714013darki_e
darkies124015753darkies
darking134217343darking
darks106727873dark_s_
dervish1436983dervish
dryish1336323_dryish
duskish1535183duskish
dwarfish1843783dwarfish
faddish15359003faddish
fairish1338993fairish
famish14311843fa_mish
fattish1359263fattish
flatfish1744933flatfish
flattish1455263flattish
folkish1736563folkish
furbish1536443furbish
furnish1337383furnish
girlish1137193girlish
grayish1437813grayish
hagfish17227613hagfish
haggish15207473haggish
haimish1537753haimish
harking154120943harking
harks126333433hark_s_
harpist12312353harpist
harsh116418053har__sh
hashish1238353hashish
hickish1936473hickish
jackfish2744123jackfish
jadish17319903ja_dish
kaddish16317973kaddish
kakis86116843ka_kis_
lacking143821543lacking
lacks116129203lack_s_
ladyfish1843803ladyfish
laich105920713la__ich
laicise939333laicise
laicism1138243laicism
laigh95515923la__igh
laith85722103la__ith
lakes95737653la_kes_
lakh114919953la_k__h
lakhs125210343la_khs_
lakier104716273la_kier
lakiest113517263la_kiest
laking115027043la_king
lanais6316793lanais_
languish12136253languish
lankest112714113lankest
lankier113711633lankier
lankiest122912493lankiest
lankily1437123lankily
lapis76223153la_pis_
larch105919793lar__ch
lardier83518343lardier
lardiest93813883lardiest
larding92917873larding
lards65331863lar_ds_
larees65323113larees_
lares54852633lar_es_
larges74824233larges_
largess8408913largess
largest83715103largest
largos74815063largos_
lari45839153lar_i__
lariat6629043lar_iat
larine63927043lar_ine
lark85733863lark___
larked114519473lark_ed
larker104519243lark_er
larkers113014513larkers
larkiness1338113larkiness
larky125218873lark__y
lars46956573lar__s_
larums83610533larums_
larvas9310233larvas_
lash76539653la___sh
lassis65216703lassis_
lathis95516173lathis_
latkes104715873latkes_
lavash12597373la_vash
leftish13197253leftish
loggish12258723loggish
longish11229093longish
lookism1335913lookism
lookist1139563lookist
loris55329153lor_is_
loudish1137983loudish
loutish1039963loutish
lowish12310533l_owish
lumpish14127383lumpish
lurking123710853lurking
lurks95218743lurk_s_
lyrism1137473lyr_ism
lyrist9312293lyr_ist
maddish14289483maddish
maidish13239553maidish
mannish121710693mannish
markas124717003markas_
marking144020133marking
marks115933483mark_s_
marsh105320853mar__sh
monkish1638243monkish
narcism1188733narcism
narcist9512443narcist
naris55735293nar_is_
narking124015383narking
narks96026033nark_s_
nerdish1137103nerdish
oafish121311723oa_fish
ogreish1134673ogreish
ogrish1039263ogr_ish
palish114718273pa_lish
panfish15229973panfish
pariah114320583par_iah
paris75145943par_is_
parkas125018023parkas_
parking143423043parking
parks116134463park_s_
parvis116114803parvis_
parvise124211693parvise
peakish16268873peakish
peckish18227293peckish
perish114619063per_ish
pinkish16279113pinkish
planish12412053pla_nish
prankish1737023prankish
puckish18237213puckish
punkish16257693punkish
quackish2654383quackish
quirkish2442993quirkish
radish103516913ra_dish
raffish1658843raffish
rakis95323443ra_kis_
rammish1437563rammish
raspish1298103raspish
ratfish1338773ratfish
rattish10510823rattish
ravish123414033ra_vish
rawish123012913ra_wish
sakis95323673sa_kis_
saltish10312163saltish
saris54544953sar_is_
sarkier113413313sarkier
sarkiest123615063sarkiest
sarks96632463sark_s_
sawfish1637683sawfish
serfish1348973serfish
sickish1638423sickish
slavish1338233sla_vish
starfish1438083starfish
tallish103313583tallish
tannish101610573tannish
tarbush1234173tarbush
vampish1766283vampish
vanish121513213va_nish
varnishy17163403varnishy
waggish15207073waggish
waifish1637703waifish
wampish1777293wampish
warking153519573warking
warks127932403wark_s_
waspish1586923waspish
weakish17217173weakish
wearish132310153wear_ish
wormish1537163wormish
zanyish2235903zanyish

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.390458182.1
2DLD Change Limit1340272485.97022450.1
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.45327691.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.