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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
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
ossa4371416(None) 
fossa85812631fossa
ossia53710401ossia
ansa45927772ansa
asea46327182asea
ass37844062ass_
assai5711542assai
assay8710282assay
boss65938342boss_
bossy105515972bossy
casa65630862casa
coss66143492coss_
costa75523732costa
dorsa64617282dorsa
doss56235042doss_
dossal75510302dossal
ess36030882ess_
essay867622essay
foss76431642foss_
fossae95510372fossae
fossas94610702fossas
fosse86119462fosse
glossa7529162glossa
gossan747232gossan
hosta85917832hosta
isba61310882isba
joss115925592joss_
koss85224822koss_
loss45337962loss_
lossy85214642lossy
lyssa835712lyssa
masa65034722masa
massa75518922massa
mesa67025482mesa
moss67641032moss_
mosso74715182mosso
mossy105217062mossy
oast47156322oast
oba57531552o_ba
obas65730932obas
obia67923112obia
oca56731732o_ca
ocas66729632ocas
oda48133052o_da
odas57230262odas
odea56224572odea
ods47546222ods_
oes35866192oes_
ohia75719362ohia
ohs66232312ohs_
oka76926802o_ka
okas85225392okas
okra86413572okra
olea46532722olea
olla44821172olla
omasa749482omasa
oms56337512oms_
ons36148512ons_
ops56641252ops_
ora37250832o_ra
orca65522772orca
orra46120722orra
ors35750112ors_
os211359882o_s_
osar46820952osar
ose38147342o_se
oses46641512oses
ostia52315582ostia
oust46747442oust
ova66823792o_va
owse76321622owse
posse74722272posse
psst66118402psst
sea36161292_sea
sha69837782_sha
ska76925862_ska
soba64927922soba
soca66330052soca
soda56329392soda
sofa75625602sofa
soja115619512soja
sola45541862sola
soma65635292soma
sora45746912sora
sos37761602sos_
soya75724432soya
spa55730812_spa
toss45637972toss_
ursa44116912ursa
vasa76522972vasa
visa76323882visa

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 Filter178691298720.890200776.4
2DLD Change Limit29872912.06314479.9
3Display Results91910.0165687.5
 (SQL Overall)178691912.96960185.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.