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

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

72 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
liviers10421107(None) 
leviers103510341leviers
livers94927821liv_ers
livier97514591livier_
livyers13365901livyers
aivers94822322aiv_ers
civies114116442civie_s
claviers1367102claviers
clivers123411752cliv_ers
divers105024962div_ers
dividers13257212dividers
diviners12308352diviners
enviers1036992enviers
fivers124420922fiv_ers
flivvers1733112flivvers
givers104817712giv_ers
ivies84215762_ivie_s
jivers164515642jiv_ers
jivier16438612jivier_
laveers10329362laveers
lavers94526362lav_ers
levers94621322lev_ers
levier94013872levier_
levies93919862levie_s
libbers113812832libbers
libers84721442li_bers
lickers134118252lickers
liers55130402l__iers
lifers95617842li_fers
lifters104313782lifters
ligers75022042li_gers
likers104620912li_kers
lilies63021412lilie_s
limbers113614742limbers
limier83518722limier_
limiters10249332limiters
limmers113413082limmers
limners93311562limners
limpers113815222limpers
liners65428852li_ners
lingers84223302lingers
linier64423792linier_
linkers114317712linkers
linters73822632linters
lippers113416442lippers
lispers94514322lispers
listers74026532listers
liters65429882li_ters
litters73422572litters
liveners11217932liveners
livens94314892liv_ens
liver85132962liv_er_
livery124910902liv_ery
lives86133192liv_e_s
livings11408922livings
livres94311862livre_s
livyer12426292livyer_
lovers94223432lov_ers
pitiers93812652pitiers
ribiers9319752ribiers
rivers94626542riv_ers
riviera1035072riviera
rivieras1143582rivieras
riviere1036372riviere
rivieres1136012rivieres
sivers95324152siv_ers
slivers104115252sliv_ers
tidiers8389772tidiers
viers85621952__viers
vivers124717362viv_ers
viziers19336202viziers
wivers125320802wiv_ers

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 Filter1786911076710.263679433.5
2DLD Change Limit107671727.45614440.9
3Display Results72720.0302400.0
 (SQL Overall)178691727.74923059.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.