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

114 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
falseness123609(None) 
baseness10910942ba_seness
falsenesses1446742falsenesses
fastness11238762fa_stness
haleness11312622hal_eness
maleness10312312mal_eness
paleness10312982pal_eness
alienees8118653_alienees
alieners889823_alieners
alienness945373_alienness
alikeness1336333_alikeness
aliveness1238223_aliveness
alkenes114212753_alkene_s
aloneness957313_aloneness
baldness1137043bal_dness
balkiness1556903balkiness
balminess1356593balminess
bareness10912813ba_reness
baseless1099563ba_seless
bassness1096743ba_ssness
blueness1038213_blueness
calmness1236643cal_mness
cassenes103611293cassene_s
causeless1135193causeless
closeness1137613closeness
coarseness1246173coarseness
denseness1046863denseness
easiness8313043ea_siness
faceless13269173fa_celess
facileness1545503facileness
fadedness1445613fadedness
fadeless12258323fa_deless
faintness1235833faintness
fairness1136563fa_irness
falconers1445323falconers
falconets1444813falconets
fallowness1642943fallowness
falsest10310013fals__est
falsettos1242713falsettos
falsies103515013fals_ie_s
falterers12238033falterers
fameless13259203fa_meless
fanciness1437673fanciness
farness102912203fa__rness
fasteners12237053fasteners
fatalness1245763fatalness
fatness103311293fa__tness
fatteners12236873fatteners
fattiness12239373fattiness
faultiness1344823faultiness
fellness1135913fel_lness
femaleness1545763femal_eness
filminess1435983filminess
fineness11310643f_ineness
firstness1245003firstness
flakiness1636473flakiness
flameless1435353flameless
flashiness16105283flashiness
flatness1138153f_latness
fleetness1244753f_leetness
flenses1039473f_l_enses
flushness1544893flushness
folksiness1743573folksiness
freeness11710443f_reeness
freshness1545943freshness
fullness1135443ful_lness
fulness10248963ful__ness
fulsomeness1652813fulsomeness
fuseless11237233f_useless
fussiness12226583fussiness
gameness112810693ga_meness
gassiness10268313gassiness
gastness9278473ga_stness
halfness1435563hal_fness
harshness1545963harshness
hoarseness1345293hoarseness
idleness936843idl_eness
lameness102612673la_meness
largeness1038273largeness
lateness82614073la_teness
looseness937463looseness
maltiness112910573maltiness
massiness112810143massiness
naiveness1277483naiveness
obeseness1145873obeseness
pastness102510503pa_stness
pilseners1144943pilseners
planeness1138153planeness
rareness81112853ra_reness
rashness1138093ra_shness
safeness11239633sa_feness
sageness92111983sa_geness
saltiness93312113saltiness
saltness82610243sal_tness
sameness102712683sa_meness
saneness82313723sa_neness
sarsenets946513sarsenets
sassiness8249333sassiness
soleness8814263sol_eness
sparseness1245493sparseness
staleness9310783stal_eness
talkiness1356913talkiness
tallness837103tal_lness
tameness102411253ta_meness
tenseness947113tenseness
terseness948403terseness
vagueness1343933vagueness
validness13125363validness
valueless1242843valueless
valveless1543163valveless
vastness11257293va_stness
vileness1139983vil_eness
waeness102512783wa__eness
wiseness112010753_wiseness

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.1701051123.5
2DLD Change Limit1486411146.98621277.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.