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

83 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
rubylike175335(None) 
quaylike2434142quaylike
raylike14269252r_aylike
riblike1337332rib_like
rufflike1843252rufflike
ruglike1236282ru_glike
runelike1236032runelike
rushlike1534332rushlike
tubelike1436092tubelike
tublike1337082tub_like
auntlike1234983auntlike
belike124616283__belike
biblike1536893bib_like
bubaline1247163bubaline
budlike14257873bu_dlike
bushlike1734963bushlike
byline11311643__byline
claylike1734463claylike
crablike1636023crab_like
cultlike1434933cultlike
cuplike1537213cu_plike
drumlike1543793dru_mlike
dunelike1335303dunelike
dustlike1335363dustlike
fruitlike1642853fruitlike
fumelike1735223fumelike
fuselike1535673fuselike
gulflike1643453gulflike
gumlike14317403gu_mlike
gutlike12308653gu_tlike
guyline11258173gu_yline
hoblike16158303hob_like
husklike1433613husklike
hutlike14349063hu_tlike
ivylike1734283_ivylike
jutelike1935333jutelike
ladylike1634683ladylike
lilylike1543853lilylike
niblike1336703nib_like
nunlike11258073nu_nlike
nutlike113110113nu_tlike
playlike1735613playlike
pumplike1834373pumplike
puppylike1941583puppylike
puslike1347563pu_slike
pusslike1434033pusslike
puttylike1841813puttylike
rashlike1535793rashlike
ratlike113912353r_atlike
reedlike1336213reedlike
ringlike1336243ringlike
rocklike1335903rocklike
rodlike1288263r_odlike
rooflike1534623rooflike
rootlike1236613rootlike
ropelike14157853ropelike
roselike12169183roselike
rubberlike1852153rubberlike
rubble104315673rubbl__e
rubblier1244913rubblier
rubbling13238073rubbling
rubellite1143583rubellite
ruble74521253rub_l__e
rubying13297933ruby_ing
ruralise839643ruralise
ruralite848963ruralite
ruralize1739233ruralize
shrublike1842713shrub_like
skylike1336103_skylike
sublime11310363sub_lime
subline9316893sub_line
suchlike1735123suchlike
suitlike1236313suitlike
sunlike112310573su_nlike
surflike1535933surflike
toylike14157243_toylike
turflike1534443turflike
tusklike1133583tusklike
unalike11311533_unalike
unlike102614063_u_nlike
urnlike1136713_urnlike
weblike1635923web_like
wheylike2143403wheylike

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 Filter1786911461620.406440125.6
2DLD Change Limit146162836.58022213.1
3Display Results83830.0302766.7
 (SQL Overall)178691837.01625469.1
 
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.