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

116 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
irateness931049(None) 
braveness14237762braveness
grateless10277572grateless
graveness13288382graveness
inaneness948382inaneness
innateness1046892innateness
iratenesses11411402iratenesses
lateness82614072_lateness
ornateness1046702ornateness
rareness81112852_rareness
triteness9310362triteness
acuteness1145863acuteness
animateness1355683animateness
artiness81615403ar_tiness
awareness1236343awareness
bareness10912813_bareness
baseness10910943_baseness
brakeless1544993brakeless
brashness1436323brashness
brattiness1255833brattiness
brazenness2142883brazenness
cateress102311603_cateress
chasteness1546523chasteness
craftiness1545743craftiness
crassness1136213crassness
cravenness1543873cravenness
craziness2037383craziness
crudeness1245753crudeness
cuteness1039673_cuteness
datedness1187753_datedness
dateless9259963_dateless
diluteness1145183diluteness
direness9311303dir__eness
dirtiness1039463dir_tiness
drabness1135803dra_bness
draftiness1444853draftiness
elatedness1146033elatedness
fatness103311293_fat_ness
finiteness1347113finiteness
firstness1245003first_ness
flatness1138153flat_ness
frailness1236533frailness
frameless1435533frameless
frankness1655223frankness
freeness11710443fr_eeness
gameness112810693_gameness
gateless9279953_gateless
graceless12226883graceless
gradeless11236703gradeless
grandness1138303grandness
grapiness1238243grapiness
gratinees10307313gratinees
graveless13226693graveless
grayness1235933gra_yness
greatness1036893great_ness
haleness11312623_haleness
hirsuteness1452943hirsuteness
idleness936843i_dleness
inaptness1144333inaptness
insaneness1046493insaneness
iratest7312483irat__est
ireless72312243ir__eless
ironness836953ir_onness
isatines8310663isatine_s
lameness102612673_lameness
largeness1038273largeness
liteness82213213_liteness
literateness1256403literateness
loathness1244703loathness
maleness10312313_maleness
mateless102711293_mateless
mateyness1444473_mateyness
matiness102114743_matiness
meatiness11311173meatiness
minuteness1245293minuteness
muteness1039013_muteness
neatness839153neat_ness
oblateness1244883oblateness
oratress834553orat_ress
paleness10312983_paleness
patness92912283_pat_ness
planeness1138153planeness
pretenses112210583pretenses
primeness1338653primeness
privateness1655703privateness
proneness11310443proneness
raciness102413453_raciness
rankness12267943_rankness
raptness1046733_raptness
rashness1138093_rashness
ratines75328583_ratine_s
ratteners9237263_ratteners
raveners11309123_raveners
rawness1038153_ra_wness
retenes76324623_retene_s
rifeness1138583_rifeness
ripeness1039363_ripeness
rudeness938083_rudeness
safeness11239633_safeness
sageness92111983_sageness
sameness102712683_sameness
saneness82313723_saneness
sedateness1146663sedateness
slatiness92511363slatiness
spareness1139863spareness
staleness9310783staleness
stateless937563stateless
suaveness1247693suaveness
tameness102411253_tameness
tartiness92112053tartiness
tartness82210133tart_ness
traceless11228643traceless
trueness838683tr_ueness
waeness102512783_wa_eness
whatness1435093what_ness
whiteness1546483whiteness

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.1701051123.5
2DLD Change Limit1486411168.51617454.3
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.73220463.9
 
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.