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 “groundless” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

55 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
groundless124347(None) 
boundless1235182_boundless
grounders1156782ground_ers
groundlessly1751792groundlessly
groundmass1451932groundmass
groundsels1242382groundsels
roundlets10175292_roundlets
roundness1047012_roundness
soundless1035532_soundless
woundless1334032_woundless
bondless1148813_bo_ndless
boundness1235943_boundness
brandless1236123br_andless
broodless1235033bro_odless
cloudless1243153clou_dless
countless1146373_countless
crownless1443423crown_less
friendless1442543friendless
frontless1235403fro_ntless
glandless1134163g_landless
godless938403g_o__dless
grainless1035893grain_less
grandness1138303gr_andness
greedless1144893gr_eedless
grounded1136573ground_e_d
grounder1047613ground_e_r
groundfish1851913groundfish
groundhogs1651833groundhogs
groundings1343743groundings
groundling1343393groundling
groundlings1442073groundlings
groundnuts12142183groundnuts
groundouts12123193groundouts
grounds9228313ground___s
groundsel1142783groundse_l
groveless13235363gro_veless
gruntles9287233gr_untle_s
gunless8299633g__un_less
nounless837253_noun_less
proudness1246693prou_dness
rindless92510193_r_indless
roadless937703_ro_adless
rodless8310073_ro__dless
rotundness1143403_rotundness
roundels9217753_round_els
rounders92613693_round_ers
roundest9310473_round_est
roundlet9209223_roundle_t
rundles83214713_r_undle_s
rundlets9307363_r_undlets
rungless956733_r_ungless
runless72810423_r_un_less
soundness1036963_soundness
trundlers10215003tr_undlers
trundles9278483tr_undle_s

Search took 7 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 Filter1786911406030.1561145455.1
2DLD Change Limit140603555.90623806.8
3Display Results55550.0163437.5
 (SQL Overall)178691556.07829399.6
 
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.