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

91 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
olives9431395(None) 
lives86133191_lives
ogives10367911ogives
olive84817151olive_
alines65735222alines
alive85722512alive_
blites84721212blites
bolides10515072bolides
chives144317592chives
claves115020062claves
climes104720002climes
clines84926042clines
clivers123411752clivers
cloves114918822cloves
colies84837052coli_es
dives95832402_dives
drives105117112drives
elides74420692elides
elites66027122elites
elves85118742el_ves
fives116027362_fives
flies85630712fli_es
flites95122442flites
gives95324872_gives
glaives11347832glaives
glides84518862glides
glimes94717522glimes
gloves104115182gloves
hives116925512_hives
holies94630032holi_es
iolites73819482iolites
jives154820812_jives
knives13458552knives
laves86039152_laves
lies46454192_li_es
likes96231902_likes
limes75636502_limes
lines57054572_lines
live76540992_live_
lived95523722_lived
liven85021732_liven
livens94314892_livens
liver85132962_liver
livers94927822_livers
livest95315732_livest
livres94311862_livres
loaves94813852loaves
loves85332012_loves
lowlives1434572lowlives
molies84429512moli_es
motives123611892motives
naives94914222naives
nonlives1138362nonlives
oaves84925612o_aves
obliges1037142obliges
ogive9379092ogive_
oldies7314422oldies
oldwives1542462oldwives
oleines7313392oleines
oles46453472ol__es
olios54520852oli_os
olivines1137472olivines
oolites72817842oolites
opines84820702opines
outlives112511762outlives
ovines94614342ovines
oxides14109692oxides
oximes15107422oximes
plies74526512pli_es
polices113118052polices
polies84034582poli_es
reives95723042reives
relives104619442relives
rives85336002_rives
shives124921412shives
skives134113942skives
slaves95023022slaves
slices84022852slices
slides73922182slides
slieves10378962slieves
slimes84722042slimes
slipes84921412slipes
sliver94116592sliver
slivers104115252slivers
solves95018222sol_ves
swives123915182swives
unlives102010952unlives
votives13337952votives
waives123714182waives
wives115328922_wives
wolves124510852wol_ves

Search took 4 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 Filter178691825510.1101624463.6
2DLD Change Limit82551913.05027065.9
3Display Results91910.0303033.3
 (SQL Overall)178691913.19056016.0
 
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.