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

145 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
ceaseless113573(None) 
creaseless1243641creaseless
baseless1099562_baseless
careless102813632c_areless
cashless1336772c_ashless
causeless1135192causeless
ceaselessly1652432ceaselessly
classless1143842classless
feastless1235042feastless
greaseless1143482greaseless
menseless1145202menseless
senseless945972senseless
teaselers9165842teaselers
yeastless1234052yeastless
ageless8310343__ageless
ashless10318453__ashless
aweless1038723__aweless
baseness10910943_baseness
beakless14297383bea_kless
beamless12327003bea_mless
beardless1234913beardless
beatless103311593bea_tless
bladeless1234303bladeless
blameless1334733blameless
brakeless1544993brakeless
capelets1268603c_apelets
capless114312763c_a_pless
carless95118493c_a_rless
caseases10410473c_aseases
caseoses1039293c_aseoses
castles94917733c_astle_s
cateress102311613c_ateress
ceases84427073ceas__e_s
centerless1245003centerless
chadless1436403cha_dless
changeless1643873changeless
charmless1633583charmless
chartless1435703chartless
chasteness1546523chasteness
chiselers1445453chiselers
clawless1334123cla_wless
closeness1137613closeness
clueless1035883c_lueless
coalless1038193coa_lless
coarseness1246173coarseness
coatless1039693coa_tless
codeless112010113c_odeless
coreless103013833c_oreless
corselets1147313corselets
costless10310003c_ostless
crassness1136213crassness
crestless1146783crestless
crimeless1335063crimeless
crustless1155403crustless
cureless10319703c_ureless
dateless9259963_dateless
deathless1335223deathless
denseness1046863denseness
earless74316073_ea_rless
easeled8159853_easele_d
easels65914553_easel__s
easiness8313043_easiness
edgeless1034883_edgeless
eyeless1058053_e_yeless
faceless13269173_faceless
fadeless12258323_fadeless
fameless13259203_fameless
fearless1137873fea_rless
feeless103511103fe__eless
fenceless1444163fenceless
flameless1435353flameless
frameless1435533frameless
fuseless11237233_fuseless
gasless8319013_gas_less
gateless9279953_gateless
gearless937373gea_rless
glassless1043873glassless
graceless12226893graceless
gradeless11236703gradeless
grassless1034303grassless
grateless10277583grateless
graveless13226693graveless
headless12289863hea_dless
heartless1236393heartless
heathless1535593heathless
heatless113011463hea_tless
horseless1237213horseless
houseless1237463houseless
laceless10239853_laceless
leaderless1143433leaderless
leadless9248793lea_dless
leafless11246573lea_fless
leakless12246983lea_kless
lensless835583lens_less
maneless102812343_maneless
massless10277113_massless
mastless102610023_mastless
mateless102711293_mateless
mealless10288363mea_lless
measles92412753meas_le_s
measureless1371733measureless
meatless103410863mea_tless
nameless10248373_nameless
nerveless1243933nerveless
newsless1134533news_less
noiseless945553noiseless
noseless839513_noseless
paneless102611763_paneless
passless10247223_passless
pastless102411203_pastless
peakless14236683pea_kless
placeless1335613placeless
reasonless1043523reasonless
reassess836513reas_sess
restless82713163re_stless
sashless1136603_sashless
scaleless1135513scaleless
seamless10238723sea_mless
seasonless1043373seasonless
seatless83213003sea_tless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
spaceless1335733spaceless
stateless937563stateless
tameless10259903_tameless
tapeless10218643_tapeless
tasteless935673_tasteless
tearless848713tea_rless
teaseled9186793teasele_d
teaseler8176573teasele_r
teasellers1043953teasellers
teasels74311313teasel__s
tenseness947113tenseness
terseness948403terseness
traceless11228643traceless
useless7188423__useless
vestless11258843ve_stless
wageless1237173_wageless
wakeless1536473_wakeless
waveless1437483_waveless
weariless1234763weariless
weaseled12175143weasele_d
weasels10468503weasel__s
zestless17247433ze_stless

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411456.51622811.7
3Display Results1451450.0602416.7
 (SQL Overall)1786911456.99925530.9
 
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.