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

92 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
livre8561325(None) 
lire47845291li_re
litre55421461litre
live76540991liv_e
liver85132961liver
livres94311861livres
aiver85725162aiver
alive85722512aliv_e
cire65836372ci_re
civie103716352civie
dire56644142di_re
dive85634772div_e
diver94827802diver
fibre104812842fibre
fire76245592fi_re
five107629742fiv_e
fiver116024942fiver
give85829352giv_e
giver94921202giver
hire75538962hi_re
hive106029672hiv_e
ire36943172_i_re
jive146123592jiv_e
jiver155119052jiver
lave75642142lav_e
laver85031792laver
levee84023812levee
lever85125162lever
liane54720662liane
liar47229682liar_
liard65418592liard
liars54723162liars
liber74723612liber
libra74712422libra
librae84310172librae
libri74610112libri
lice66045062li_ce
lie38264522li__e
liege65314432liege
lier45942462lier_
lierne638022lierne
liers55130402liers
lieve86315472lieve
liever94611862liever
life75433732li_fe
lifer85822152lifer
liger65024462liger
ligure7279472ligure
like86040842li_ke
liker95627062liker
lime66244932li_me
line46965572li_ne
liner55938912liner
lipe66839732li_pe
lira46928682li_ra
liri45128252li_ri
lisle53916722lisle
lite47054542li_te
liter54736342liter
lithe84922012lithe
litres65220392litres
lived95523722lived
liven85021732liven
livered113111632livered
livers94927822livers
livery124910892livery
lives86133192lives
livid96714422livid
livier97514592livier
livyer12426292livyer
lore45850352l_ore
louvre9425682louvre
love75234762lov_e
lover85526452lover
lucre76415522lucre
lure45142462l_ure
lyre75623792l_yre
mire66748222mi_re
mitre75522422mitre
nitre57519682nitre
olive84817152oliv_e
rive75537722riv_e
river85731692river
sire46150412si_re
siver85728612siver
sliver94116592sliver
tire46143352ti_re
titre54619392titre
vive105426622viv_e
wire75839812wi_re
wive105931752wiv_e
wiver115924512wiver

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit53800921.86028924.7
3Display Results92920.0332787.9
 (SQL Overall)178691921.98689975.3
 
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.