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 “plantlike” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
plantlike154494(None) 
planetlike1643031planetlike
antlike11312072__antlike
flintlike1643122flintlike
giantlike1443262giantlike
platelike1546142platelike
playlike1735612pla_ylike
auntlike1234983_auntlike
batlike133311883_ba_tlike
beanlike14146843bean_like
bladelike1643833bladelike
blanketlike1651013blanketlike
boatlike1457963boa_tlike
catlike132712933_ca_tlike
clamlike1635163cla_mlike
clawlike1733913cla_wlike
claylike1734463cla_ylike
fanglike1636823_fanglike
fanlike142610503_fan_like
fatlike142911193_fa_tlike
flamelike1845063flamelike
flatline11298923fla_tline
gantline9410903_gantline
gladelike1544153gladelike
glenlike1334043glen_like
gnatlike1334743gna_tlike
goatlike1346293goa_tlike
handlike1639153_handlike
hatlike143311713_ha_tlike
lacelike1438493_lacelike
ladylike1634683_ladylike
lakelike1137383_lakelike
lamblike1636153_lamblike
landline9311443_landline
lanoline8311953_lanoline
lardlike1336503_lardlike
lavalike1536283_lavalike
lawlike14137073_la_wlike
linelike12159003_linelike
loftlike1534393_loftlike
manlike133012783_man_like
mastlike1437863_mastlike
moatlike1446993moa_tlike
oatlike113412403_oa_tlike
palmlike1656043p_almlike
palsylike1842703palsylike
pantie84326473p_ant_i_e
pantile93918483p_ant_ile
parklike1337493p_arklike
pastalike1546723p_astalike
peaklike13115373pea_klike
pealike131211273pea__like
phantomlike2251273phantomlike
pinelike14188613p_inelike
plaintive1444623plaint_ive
planeside1285123planeside
planetwide1651983planetwide
plantable1337273plantable
plantain1047903plantai_n
plantains1147493plantains
planting113515383plant_ing
plantlet10310013plantl_et
plantlets1145013plantlets
planulae1044793planul_ae
planulate1146903planulate
playtime1544793playt_ime
plotline1037643pl_otline
plumlike1643793pl_umlike
poetlike1436733p_oetlike
potlike13910123p__otlike
ratlike113912353_ra_tlike
saintlike1344783saintlike
saltlike1237253_saltlike
sandlike1339713_sandlike
slablike1435673sla_blike
slantwise1242633slantwise
slatelike1346153slatelike
slitlike1235303sl_itlike
swanlike1535313swan_like
tanklike1136013_tanklike
tentlike1236903_tentlike
wartlike1537043_wartlike
yeastlike1672993yeastlike

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 Filter1786911486410.436409841.7
2DLD Change Limit148641836.37623312.6
3Display Results83830.0302766.7
 (SQL Overall)178691836.84226116.8
 
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.