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

107 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
ursa4411691(None) 
bursa74921521bursa
urea46528061urea
ursae55214451ursae
ansa45927772ansa
area45843392area
aria46245422aria
ars37670932ars_
arse46539272arse
aura45836252aur_a
auras55932562auras
bra56339462br_a
bras65746452bras
bura66139532bur_a
buras74736302buras
burka114617692burka
burqa165013092burqa
burs65847422burs_
bursae84515602bursae
bursal84414822bursal
bursar85413252bursar
bursas85318272bursas
burse75527252burse
burst75332242burst
casa65630862casa
curia74523772curia
curs65645542curs_
curse75829142curse
curst74931022curst
dorsa64617282dorsa
dura55232112dur_a
duras65727732duras
durra65315792durra
durst66125172durst
era35741502er_a
eras45441502eras
ers36046282ers_
erst47436432erst
furs76735042furs_
gursh94512332gursh
hurst85527192hurst
jura116024892jur_a
kurta95113912kurta
masa65034722masa
mesa67025482mesa
mura65633302mur_a
muras75329582muras
murra74519082murra
nurse54420122nurse
ora37250832or_a
orca65522772orca
orra46120722orra
ors35750112ors_
ossa43714162ossa
ours47237562ours_
presa74319042presa
proa66229962proa
purda82914692purda
purs65641042purs_
purse76028892purse
pursy105016412pursy
qursh174110842qursh
ras37575392_ras
ria36745502_ria
ruga56121232ruga
ruse45938932ruse
rush76628182rush
rusk85823312rusk
rust45544912rust
rya67622012_rya
sura45740292sur_a
suras55336332suras
surra55521342surra
ulna46317332ulna
ulva75412692ulva
uns35936762uns_
unsay83212842unsay
upas68322382upas
ups55629052ups_
urase54624692urase
urb55731112ur_b
urban72013862urban
urbia7311142urbia
urbs65922062urbs
urd46427052ur_d
urds55922432urds
ureal56722682ureal
ureas55826012ureas
urge54722422urge
urial54823022urial
uric63624942uric
urn35731472ur_n
urns46323902urns
urp56426402ur_p
urps66920482urps
ursid6311482ursid
urus46426142urus
us26937432u_s_
use36835162u_se
uta37425582u_ta
utas45924952utas
uts35534372uts_
uvea74712652uvea
vasa76522972vasa
visa76323872visa
wurst85122992wurst
yurta86014252yurta

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.280638182.1
2DLD Change Limit298721071.39021490.6
3Display Results1071070.206519.4
 (SQL Overall)1786911071.87695251.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.