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

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
senopia94923(None) 
senopias1048821senopias
sinopia947741sinopia
anopia83412392_anopia
meropia1149612meropia
senora63216162seno_ra
senorita848282senorita
sensoria8117532sensoria
sepia75318672se__pia
sinopias1047872sinopias
sinopie948782sinopie
synovia1345532synovia
aerobia939463aerobia
agnosia837643agnosia
anopias92412483_anopias
anopsia9258443_anopsia
anoxia133510023_anoxia
begonia1047213begonia
canopic1338803canopic
cecropia1455153cecropia
celosia939463celosia
ectopia1147693ectopia
encomia1147983_encomia
enoki9268873_enoki_
enokis103010273_enokis
enolic8413353_enolic
enosis63816423_enosis
entia5318203_en_tia
entopic1149953_entopic
genoa64315823geno__a
genomic1237923genomic
kenosis11369003kenosis
kenotic1359713kenotic
melodia1038883melodia
meropias1249963meropias
meropic13310263meropic
metopic1339763metopic
myopia13318443_myopia
noria55722183__noria
peloria9310953peloria
pennia84412973pen_nia
sandpit1049633sandpit
sangria838113sangria
scholia1237833scholia
scoria8513503s_coria
scotia8310803s_cotia
scotopia1245733scotopia
sedilia847243sedilia
semolina1047493semolina
senarii7269143senarii
seneca839793sen_eca
senecio947203senecio
senega738173sen_ega
sengi64016513sen_gi_
senhora10348673senhora
senhorita1244053senhorita
seniti64317223seniti_
senna54617983sen__na
sennit63117923sen_nit
senor53822803seno__r
senoras72714953senoras
senores73218113senores
senoritas946513senoritas
senors63620793seno_rs
sensa54117473sen__sa
sensei64712593sensei_
senseis73310643senseis
sensorial9117453sensorial
senti56226703sen_ti_
sepias83616103se__pias
sepic94617053se__pic
septa75518083se__pta
sequoia1644233sequoia
serosa6313023sero_sa
sinfonia1144633sinfonia
stenosis847993stenosis
stenotic1048083stenotic
subtopia1245403subtopia
syconia1248313syconia
syncopic1745633syncopic
synodic1347363synodic
synopsis1346653synopsis
synoptic1546923synoptic
synovial1444743synovial
synovias1445303synovias
tenia55324483ten__ia
tenpin8310583ten_pin
tentoria8119263tentoria
utopia8107883_utopia
xenia124814773xen__ia
xenopus1642983xenopus

Search took 7 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 Filter1786911340270.393454684.5
2DLD Change Limit134027916.53020524.8
3Display Results91910.0303033.3
 (SQL Overall)178691916.95325699.8
 
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.