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

150 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
greetings1127604(None) 
greenings11266661greenings
greeting103112351greeting_
breedings13375762breedings
crestings12298042crestings
gleeting10279172gleeting_
gratings103910762gr_atings
greeing93613782gree_ing_
greening103112532greening_
greenlings1243592greenlings
greenwings1542702greenwings
gruelings1163762gruelings
meetings11287412_meetings
reedings103510362_reedings
reelings94012562_reelings
sheetings13256712sheetings
sweetings13326182sweetings
agentings1134443agentings
agreeing10295903agree_ing_
beatings114113233_beatings
beestings12335923beestings
beltings11369253_beltings
biestings12266033biestings
bleedings13264643bleedings
breakings16297063breakings
breathings16234313breathings
breechings18273723breechings
breeding123411843breeding_
breezing20368133breezing_
breveting1536263breveting_
brewings14296693br_ewings
briefings1543733briefings
carpetings1544213carpetings
creatines112814433creatines
creating113921953creating_
creatins103617513creatin_s
creeling113513363creeling_
creeping133310103creeping_
cresting114017043cresting_
cretins93216423cr_etin_s
draftings14334203draftings
dredgings13252953dredgings
dreeing94311183dree_ing_
dressings11265373dressings
eatings84616443__eatings
erecting112415063erecting_
feelings12338933_feelings
feltings12317903_feltings
ferretings14133493ferretings
fleeting122910323fleeting_
freeing113713913free_ing_
freezing21308323freezing_
fretting122711523fretting_
frostings1335733frostings
gatings95212823g__atings
gearings10359503g_earings
geeing84313773g_ee_ing_
geldings11316163g_eldings
getting93316563g_etting_
ghostings1433483ghostings
gleanings11244643gleanings
gleeking14316493gleeking_
gleyings13283653g_leyings
grafting13319623grafting_
granting103514523granting_
grating93923183gr_ating_
gratins84119183gr_atin_s
graylings1433883graylings
grazings19337263gr_azings
greasing102811393greasing_
greatens9307593greaten_s
greediness1245833greediness
greenbugs1342503greenbugs
greenies9312673greeni_es
greenling1136753greenling_
greens75716873gree__n_s
greenwing1434693greenwing_
greeters92610113greet_ers
greets75117423greet___s
gremlins1136053gremlin_s
greying124110893gr_eying_
grieving1385893grieving_
grifting13299263grifting_
gritting10309983gritting_
groupings13273813groupings
grouting103410793grouting_
grueling1078273grueling_
gruellings1272323gruellings
grunting10269583grunting_
guesting1058463guesting_
heelings12359753_heelings
jestings16368023_jestings
keepings15345943_keepings
marketings1743163marketings
meeting103314963_meeting_
nettings9288103_nettings
parentings1355613parentings
pargetings1443713pargetings
peelings11339523_peelings
pettings11349703_pettings
preeing103817673pree_ing_
preening113115843preening_
pressings12269023pressings
printings12268103printings
ratings84217413_r_atings
readings103512643_readings
redwings13305733_redwings
reeding94124133_reeding_
reedlings11236343_reedlings
reefing114016863_reefing_
reeking123318643_reeking_
reeling83126863_reeling_
reesting93118273_reesting_
reeving113717663_reeving_
regreeting1237343regreeting_
renting84026853_renting_
resting85031183_resting_
restrings10159293_restrings
retinas74819353_r_etinas
retines75134673_r_etines
retints74717013_r_etints
retting83425883_retting_
screenings1343263screenings
seatings93614303_seatings
seeings84411293_see_ings
seemings11337643_seemings
settings93810073_settings
sheeting122712833sheeting_
sleepings12335883sleepings
sleeting93114163sleeting_
speedings13265403speedings
speerings12276843speerings
steevings13284443steevings
sweepings15345633sweepings
sweeting123911313sweeting_
teethings1344233_teethings
treating92519613treating_
treeing83414303tree_ing_
tweeting12267033tweeting_
vestings12359143_vestings
weepings14346483_weepings
weeting113816053_weeting_
weltings12388203_weltings
westings12429803_westings
wettings12348403_wettings
wheelings16284933wheelings
wreckings19233683wreckings
wresting123811833wresting_
wrestlings1442933wrestlings
writings12298113wr_itings

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 Limit1486411506.51322822.2
3Display Results1501500.0632381.0
 (SQL Overall)1786911506.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.