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

52 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
ravenlike1610386(None) 
cavelike1738212cave_like
gravelike1744512grave_like
ovenlike1535012_ovenlike
riverlike1644482riverlike
wavelike1836612wave_like
apelike13310533_ape_like
barnlike1437183ba_rnlike
basinlike1553383basinlike
cagelike1537723cage_like
camellike1745063camellike
civetlike1842703civetlike
crapelike1744933crape_like
craterlike1644013craterlike
dawnlike1634673da_wnlike
dovelike16157133dove_like
fanlike142610503fa__nlike
faunlike1534763fa_unlike
fawnlike1844143fa_wnlike
gamelike1538033game_like
gatelike1337933gate_like
glenlike1334043_glenlike
grapelike1644663grape_like
harelike1539613hare_like
henlike1448693__henlike
jadelike2035993jade_like
lacelike1438493lace_like
lakelike1137383lake_like
lavalike1536283lav_alike
manlike133012783ma__nlike
mazelike2336463maze_like
ranchlike1844083ranchlike
ranpike1335933ra__npike
rashlike1535793ra_shlike
ratlike113912353ra__tlike
ravelin102211023rave_li_n
raveling123414373rave_ling
ravelins113011603rave_lins
ravelling13269243ravelling
ravening122611293raven_ing
raylike14269253ra__ylike
reedlike1336213r_eedlike
resinlike1344363resinlike
ropelike14157853rope_like
roselike12169183rose_like
runelike1236033rune_like
saberlike1544973saberlike
tapelike1437493tape_like
valvelike1943683valve_like
vaselike1536993vase_like
veinlike1534313__veinlike
wavellite1543943wavellite

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.436409841.7
2DLD Change Limit148641527.84618944.8
3Display Results52520.0134000.0
 (SQL Overall)178691528.29521542.0
 
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.