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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
litre5542146(None) 
lire47845291li_re
lite47054541lit_e
liter54736341liter
lithe84922011lithe
litres65220391litres
livre85613251livre
mitre75522421mitre
nitre57519681nitre
titre54619391titre
antre55224522antre
bistre83815022bistre
bite66546992bit_e
biter75030032biter
blite76225352blit_e
blithe115810862blithe
cire65836372ci_re
cite65640342cit_e
citer74827322citer
dire56644142di_re
dite55547552dit_e
elite56230182elit_e
fibre104812842fibre
fire76245592fi_re
flite85424962flit_e
gite55438612git_e
goitre7349002goitre
hire75538962hi_re
ire36943172_i_re
kite85338232kit_e
kiter95523212kiter
kithe125917452kithe
late47560482lat_e
later54843922later
lathe85626712lathe
latke94817092latke
latte55426302latte
lethe85717302lethe
liane54720662liane
liar47229682liar_
liard65418592liard
liars54723162liars
liber74723612liber
libra74712422libra
librae84310172librae
libri74610112libri
lice66045062li_ce
lie38264522li__e
liege65314432liege
lier45942462lier_
lierne638022lierne
liers55130402liers
lieve86315472lieve
life75433732li_fe
lifer85822152lifer
lifter93814812lifter
liger65024462liger
ligure7279472ligure
like86040842li_ke
liker95627062liker
lime66244932li_me
line46965572li_ne
liner55938912liner
linter64625332linter
lipe66839732li_pe
lira46928682li_ra
liri45128252li_ri
lisle53916722lisle
listee64223062listee
lister64527252lister
lit39377312lit__
litai55216362litai
litas54923772litas
liters65429872liters
lither94520952lither
litho86513782litho
lits46252492lit_s
litten64014872litten
litter64324852litter
little63312162little
litu47631562lit_u
live76540992li_ve
liver85132962liver
livres94311862livres
loiter64619172loiter
lore45850352l_ore
lotte54923852lotte
lucre76415522lucre
lure45142462l_ure
lustre64011682lustre
lute46341012lut_e
lyre75623792l_yre
metre74821302metre
mire66748222mi_re
mite66249402mit_e
miter75734792miter
mitred94414342mitred
mitres83922072mitres
nite45943582nit_e
niter55028972niter
nitres65519332nitres
nitro54914352nitro
outre53922192outre
rite45849452rit_e
sire46150412si_re
site47052412sit_e
tire46143352ti_re
titer55430612titer
tithe85319702tithe
title54721072title
titres64718932titres
vitae84217632vitae
wire75839812wi_re
wite75443272wit_e
withe115220232withe

Search took 5 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.203880251.2
2DLD Change Limit538001153.97013551.6
3Display Results1151150.0631825.4
 (SQL Overall)1786911154.23642183.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.