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

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
lobar731301(None) 
allobar946662allobar
bar58070552__bar
boar66134292bo_ar
bolar75123472bolar
boyar106013762boyar
cobra95214402cobra
debar85517862debar
dobra85013102dobra
embar94011602embar
fubar1039922fubar
global937662global
goban84414072goban
hoar76729162ho_ar
isobar836142isobar
jowar155211432jowar
kabar114815552kabar
kbar106514652_kbar
kebar115113532kebar
kilobar1344612kilobar
labara83712892labara
labor75117312labor
labra75415462labra
lahar83114262lahar
lar37967532l__ar
lazar144113642lazar
lear47045952l_ear
liar47229682l_iar
liber74723622liber
libra74712422libra
lidar6312722lidar
load56730602lo_ad
loaf76734902lo_af
loam65630482lo_am
loan47436452lo_an
lob57154462lob__
lobate82915242lobate
lobber104016602lobber
lobby125113922lobby
lobe65535362lob_e
lobed86022132lobed
lobes75331002lobes
lobo67229862lob_o
lobos75921842lobos
lobs66441082lob_s
lobular936662lobular
loca65527682loca_
local74820272local
logan68123282logan
loner55431042loner
loper75129232loper
loral55927822loral
loran55925092loran
loser54728672loser
lota47233502lota_
lotah85315852lotah
lotas55926302lotas
lour45430682lo_ur
lovat8321042lovat
lover85526452lover
lower85830412lower
loyal84513482loyal
lumbar103610592lumbar
lunar57017312lunar
molar75223092molar
oar37057952_o_ar
oba57531552_oba_
obas65730932_obas
osar46820952_osar
polar75623452polar
rebar75420192rebar
roar46328572ro_ar
soar46838672so_ar
soba64927922soba_
sobas74424252sobas
sober74822412sober
sofar86115492sofar
solar55927342solar
sonar56523422sonar
sowar85821342sowar
tolar55524112tolar
unbar71913612unbar
volar86917412volar

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.310576422.6
2DLD Change Limit53800831.78330173.9
3Display Results83830.0302766.7
 (SQL Overall)178691832.12384169.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.