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

162 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
stateless93756(None) 
dateless9259962_dateless
gateless9279952_gateless
grateless10277582grateless
mateless102711292_mateless
scaleless1135512scaleless
scatheless1542922scatheless
seatless83213002seat_less
shadeless1335732shadeless
shameless1435922shameless
shapeless1435562shapeless
spaceless1335732spaceless
stackless1555932stackless
stainless9176492stainless
stairless9185622stairless
staleness9310782staleness
stalkless1333722stalkless
stampless1334542stampless
starless81610842sta_rless
stateliest1046352stateliest
stateliness1144232stateliness
styleless1243412styleless
tameless10259902_tameless
tapeless10218642_tapeless
tasteless935672_tasteless
ageless8310343__ageless
astuteness1044753astuteness
aweless1038723__aweless
baseless1099563_baseless
bathless13127383_bathless
beatless103311593beat_less
bladeless1234303bladeless
blameless1334733blameless
brakeless1544993brakeless
careless102813633_careless
cateress102311613_cateress
ceaseless1135733ceaseless
coatless1039693coat_less
deathless1335223deathless
faceless13269173_faceless
fadeless12258323_fadeless
fameless13259203_fameless
fatless103212203_fat_less
flameless1435353flameless
frameless1435533frameless
graceless12226893graceless
gradeless11236703gradeless
graveless13226693graveless
hatless103813443_hat_less
heathless1535593heathless
heatless113011463heat_less
irateness9310493irateness
laceless10239853_laceless
lateness82614073_lateness
maneless102812343_maneless
matless93014043_mat_less
meatless103410863meat_less
nameless10248373_nameless
natheless1244963natheless
nathless11127023_nathless
noteless839403_noteless
paneless102611763_paneless
pathless13138043_pathless
placeless1335613placeless
platelets1165763platelets
safeness11239633s_afeness
sageness92111983s_ageness
sailless82410373s_ailless
saltless8259343s_altless
sameness102712683s_ameness
sandless93212343s_andless
saneness82313723s_aneness
sapless93313443s_a_pless
sashless1136603s_ashless
sateens73710753s_ate_ens
scarless10189053sca_rless
scoreless1155603scoreless
seamless10238723sea_mless
sedateness1146663sedateness
senseless945973senseless
sheetless1235823sheetless
shitless11249243shit_less
shoeless1137803s_hoeless
shoreless1236633shoreless
skatoles1236143skatole_s
slatiness92511363slatiness
slitless8268143slit_less
smileless1134693smileless
smokeless1543553smokeless
snapless10287463sna_pless
soapless10278073soa_pless
soleless8910033s_oleless
spanless10247363spa_nless
spareness1139863spareness
spatzles1935303spatzle_s
spiceless1335923spiceless
spineless1136133spineless
spotless1037043spot_less
stabiles10311403stabile_s
stableness1248823stableness
stablers103611153sta_blers
stables93219073sta_ble_s
stablest103312943sta_blest
staddles10258693staddle_s
staginess1038753staginess
staidness1037033staidness
stales65538293sta__le_s
stalest73720173sta__lest
stapedes11197753stapede_s
stapelias1145103stapelias
staplers103111203sta_plers
staples93617213sta_ple_s
starkness1335963starkness
starlets81610083sta_rlets
startlers9236743startlers
startles82111963startle_s
statelier945653statelier
stately10310223statel__y
statement1148793statement
statements1256883statements
staters73922343stat__ers
states64337083stat__e_s
statices102712343statice_s
statives112710793stative_s
statues74614903stat_ue_s
statures83711113stature_s
statuses8409543statuse_s
statutes8368893statute_s
steles63725663s__tele_s
stemless1036653st_emless
stingless1046463stingless
strapless1135793strapless
strifeless1343213strifeless
stripeless1243283stripeless
stuffless1543543stuffless
suaveness1247703suaveness
systemless1541993systemless
tableless1145033_tableless
tackless14419483_tackless
tactless10288463_tactless
tailless8239083_tailless
tameness102411253_tameness
tankless12267823_tankless
tattlers8369693_tattlers
tattles73616283_tattle_s
taxless1436913_ta_xless
tideless9269083_tideless
tieless72512563_t_ieless
timeless10239543_timeless
tireless82510263_tireless
toeless72612393_t_oeless
toneless8610393_toneless
traceless11228643traceless
treeless839283_treeless
tubeless1037023_tubeless
tuneless837913_tuneless
voteless1137493_voteless
wageless1237173_wageless
wakeless1536473_wakeless
waterless1238013_waterless
wattless11268723_wattless
waveless1437483_waveless

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411627.50019818.8
3Display Results1621620.0762131.6
 (SQL Overall)1786911627.99922339.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.