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

137 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
osar4682095(None) 
oar37057951o_ar
soar46838671soar
tsar47819801tsar
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
ar211379382__ar
bar58070552_bar
bear66844642bear
boar66134292boar
bolar75123472bolar
boyar106013762boyar
car59165562_car
char95132152char
costar85518612costar
czar156013132czar
dear55343602dear
doser66228562doser
ear36867882_ear
escar74011992escar
eskar9457452eskar
far67762602_far
fear75337792fear
fiar76427332fiar
gar47259902_gar
gear55934972gear
gnar56021382gnar
guar56923292guar
haar77323492haar
hear76143882hear
hoar76729162hoar
hoser811529762hoser
izar136616012izar
jar107646152_jar
jowar155211432jowar
kbar106514652kbar
knar85818722knar
kyar116916842kyar
lar37967532_lar
lear47045952lear
liar47229682liar
lobar7313012lobar
loser54728672loser
maar66025062maar
mar57965952_mar
molar75223092molar
near45236502near
oaf65952882o_af
oak76238652o_ak
oars46846032o_ars
oast47156322oast
oat39888262o_at
oba57531552oba_
obas65730932obas
oca56731732oca_
ocas66729632ocas
oda48133042oda_
odah87018932odah
odas57230262odas
odor55718092odor
ofay106416102ofay
ogam75120032ogam
oka76926802oka_
okas85225392okas
okay115917662okay
okra86413572okra
omer67028392omer
opah96218402opah
opal66923522opal
or27354732o__r
ora37250832ora_
orad56031692orad
oral47638122oral
orra46120722orra
os211359882os__
ose38147342os_e
oses46641512oses
osier53518012osier
ossa43714162ossa
ottar54313992ottar
our36042892o_ur
ova66823792ova_
oval77119522oval
ovary1149112ovary
over77227342over
oyer75927652oyer
par57467022_par
pear69745232pear
polar75623452polar
poser75128772poser
rear45644552rear
roar46328572roar
rosary92810352rosary
sab56563202_sab
sac57452862_sac
sad47459202_sad
sae38365182_sae
sag46163402_sag
sal36462882_sal
sap56463232_sap
sard55344242_sard
sari45444042_sari
sark84938972_sark
sat36288482_sat
sau36356572_sau
saw68255352_saw
sax107447642_sax
say67264762_say
scar66434202scar
sear47353842sear
ser36752402_ser
sir35746672_sir
soak87227662soak
soap65831132soap
soars54732512soars
sofar86115492sofar
solar55927342solar
sonar56523422sonar
sora45746912sora
sour45935892sour
sowar85821342sowar
spar65433302spar
star48037762star
tar37570692_tar
tear45242882tear
tolar55524112tolar
tsars56717112tsars
tzar136315372tzar
user45023002user
var66148332_var
volar86917412volar
war67262422_war
wear75836722wear
yar67253832_yar
year76534252year

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721370.90632971.3
3Display Results1371370.0304566.7
 (SQL Overall)1786911371.202148661.4
 
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.