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 “liverish” 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
liverish144786(None) 
cleverish1743492cleverish
feverish1745412feverish
lickerish1844422lickerish
liveried1238732liveried
liveries11314372liveries
livering122012382livering
livers94927822liver_s_
tigerish1246562tigerish
viperish1655892viperish
aivers94822323aiver_s_
bitterish1446133bitterish
cavefish1974853cavefish
cherish15310463_cherish
clivers123411753cliver_s_
dimerism1347213dimerism
divers105024963diver_s_
diverse11429993diver_se
diverts114412033diverts_
etherish1448273etherish
filefish1745593filefish
fivers124420923fiver_s_
gibberish1742583gibberish
givers104817713giver_s_
jivers164515643jiver_s_
lavers94526363laver_s_
lavish124112983lav__ish
levering122212503levering
levers94621323lever_s_
libelist10310823libelist
libers84721443liber_s_
liers55130403li_er_s_
lifers95617843lifer_s_
ligers75022043liger_s_
lightish1556623lightish
likers104620913liker_s_
likewise1543263likewise
limerick1645403limerick
linearise946433linearise
liners65428853liner_s_
lionfish1454093lionfish
liquorish2152543liquorish
liters65429883liter_s_
littlish1145043littlish
livelier1136873livelier
liveliest1247093liveliest
livelily1444103livelily
liveness112411393liveness
livening12248153livening
livens94314893live_ns_
liver85132963liver___
livered113111633liver_ed
livery124910903liver__y
lives86133193live__s_
livest95315733live__st
liviers104211073livier_s_
livres94311863liv_res_
livyers13365903livyer_s_
lovers94223433lover_s_
overfish1737893_overfish
perish114619063__perish
pipefish1844533pipefish
queerish2045313queerish
riverine11310803riverine
rivers94626543river_s_
silverfish1952173silverfish
sivers95324153siver_s_
slivering1338083slivering
slivers104115253sliver_s_
spiderish1544493spiderish
tigrish1137573ti_grish
tilefish1445453tilefish
tovarish1445123tovarish
verism113214263__verism
verist93823893__verist
vigorish1545173vigorish
viperfish2042943viperfish
vivers124717363viver_s_
vixenish2142983vixenish
waterish14310533waterish
winterish1546643winterish
wiverns13366963wiverns_
wivers125320803wiver_s_

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.1731032896.0
2DLD Change Limit146162837.65619091.2
3Display Results83830.0302766.7
 (SQL Overall)178691837.85922737.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.