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

201 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
clayish154794(None) 
cladism1238552cladism
cladist10311972cladist
clannish1345262clannish
clash106219032cla__sh
clayier1248322clayier
clayiest1337922clayiest
claying133614302claying
clays105521332clay_s_
coyish143710392c_oyish
crayfish1944252crayfish
grayish1437812grayish
ladyish14287822_ladyish
latish92416172_latish
lavish124112982_lavish
lazyish22265852_lazyish
planish12412052planish
slavish1338232slavish
apish105116633__apish
babyish1736513babyish
baldish1339503baldish
banish111416043_banish
beamish14259293beamish
bearish123013273bearish
beauish12268513beauish
blackish1976713blackish
blandish1497003blandish
bleakish1745053bleakish
blemish1436603blemish
blueish1236483blueish
bluish1159243bl_uish
boarish123911913boarish
boyish142911233_boyish
caddish143810133caddish
cadis84428503c_adis_
calabash1544253calabash
calash11312433c_alash
caliph13311403c_aliph
calypso1443123calypso
camisa103114323c_amisa
camise103319633c_amise
carlish12312773carlish
cash96636283c_a__sh
catfish1559023catfish
cattish12410723cattish
cays95437673c_ay_s_
cayuse11207763c_ayuse
chais107530313cha_is_
chaise114916413cha_ise
chamisa14328853chamisa
chamise143612853chamise
chamiso14348653chamiso
charism14712203charism
chays135319743chay_s_
cheapish1844333cheapish
cherish15310463cherish
clach124617823cla__ch
clachs133511323clachs_
clacks144516343clacks_
clades94920463clades_
cladisms1336093cladisms
cladists1136723cladists
clads85722733cla_ds_
clags85621123cla_gs_
claim95616913cla_i_m
claims105211573cla_ims
clamps124515083clamps_
clams95127673cla_ms_
clangs95113613clangs_
clanks124615183clanks_
clans75031013cla_ns_
claps95626183cla_ps_
claries93422203claries
clarify1536093clarify
clarion9311663clarion
clarity12310913clarity
claros84015113claros_
clasp95517193cla__sp
clasps104512093clasps_
class75525483cla__ss
classic113710113classic
classis93712723classis
classism12407173classism
classist104010383classist
classy11379043cla_ssy
clast76030583cla__st
clasts84817293clasts_
clause84311503cla_use
claves115020063claves_
clavi104912923clavi__
clavier1239173clavier
clavus11347353clavus_
clawing133812673clawing
claws106020833cla_ws_
clay95927413clay___
clayed125013043clay_ed
clayey14407663clay_ey
claylike1734463claylike
claypan1434313claypan
clerisy1246823clerisy
clerkish1744263clerkish
clevis1158963clevis_
cliquish2244023cliquish
cloddish1544233cloddish
clonism1138983clonism
clownish1643803clownish
cloying133511753cloying
cloys104916943cloy_s_
clubbish1743813clubbish
clumpish17164893clumpish
coalfish1635493coalfish
coatis85122603coatis_
cockish1838503cockish
codfish1637163codfish
coldish1399303coldish
coltish121310933coltish
coolish12312523coolish
copyist1439053copyist
cowfish1836433cowfish
crankish1736513crankish
crash109120013cra__sh
crasis85020473crasis_
crawfish1944233crawfish
cronish12310863cronish
cubbish1635803cubbish
cuish10313173c__uish
cultish12139113cultish
currish1238353currish
czarism2056423czarism
czarist18710223czarist
danish101513793_danish
deafish1438533deafish
dryish1336323_dryish
elfish1267963el_fish
elvish1277563el_vish
evanish1337653evanish
famish14311843_famish
flash115716213fla__sh
flatfish1744933flatfish
flattish1455263flattish
flaying143914463flaying
flays116321053flay_s_
flemish1536373flemish
fluish1239333fl_uish
fogyish1735363fogyish
garish104516923_garish
glacis94012133glacis_
goatish1139563goatish
goyish13379013_goyish
grayfish1844483grayfish
greyish1435173greyish
jadish17319903_jadish
knavish1743993knavish
laddish12299723_laddish
ladyfish1843803_ladyfish
laich105920713_la_ich
laigh95515923_la_igh
laith85722103_la_ith
lapis76223153_lapis_
largish1138603_largish
laris54737463_laris_
larkish1439083_larkish
lash76539653_la__sh
lavash12597373_lavash
layin84720333_layi_n
laying104525703_laying
layins93817653_layins
lays76043253_lay_s_
lowish12310533_lowish
marish114319053_marish
oafish121311723_oafish
oldish10169313ol_dish
palish114718273_palish
parish115022353_parish
peakish16268873peakish
pixyish2253653pixyish
plash104616563pla__sh
platyfish2042683platyfish
playas114612283playas_
playing133816093playing
playlist1347573playlist
plays106320773play_s_
plenish1239943plenish
radish103516913_radish
rakish134313963_rakish
ravish123414033_ravish
rawish123012913_rawish
saltish10312163saltish
slash84719683sla__sh
slaying113316843slaying
slays85723683slay_s_
slowish1337633slowish
tallish103313583tallish
toadish1139063toadish
toadyish1544153toadyish
toyish122911123_toyish
vanish121513213_vanish
weakish17217173weakish
wearish132310153wearish
wheyish1944063wheyish
zanyish2235903zanyish

Search took 9 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.406440125.6
2DLD Change Limit1340272017.67017474.2
3Display Results2012010.0802512.5
 (SQL Overall)1786912018.15621909.1
 
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.