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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
signore832909(None) 
ignore7269061_ignore
signor73510351signor_
signora8348501signora
signori8347891signori
signors83410911signors
signory11427521signory
ignored9226442_ignored
ignorer8276102_ignorer
ignores8269002_ignores
pignora10306362pignora
seignory1244162seignory
signage937772signage
signee73617232sign_ee
signer74015632signer_
signers84714442signers
signior835042signior_
signiori943352signiori
signiors944922signiors
signiory1243562signiory
signoras9306552signoras
signories10107852signories
signorine1045172signorine
snore55424952s__nore
assignor942993assignor_
assignors1043243assignors
bighorn1346063bighorn
diagnose1045123diagnose
figure10258833fig_ure
figwort1448223figwort
gnome84213953__gnome
gore55744963__g_ore
hognose11117243hognose
ignite71410583_ignite
ignoble1043613_ignoble
ignorers9215243_ignorers
inure54119053_i_nure
ionone6313443_ionone
lignite81310303lignite
ligure7279473lig_ure
mignon937953migno_n
mignonne1142913mignonne
mignons1037863mignons
minor74920063mi_nor_
minored10310103mi_nored
minors85117103mi_nors
pignoli1045443pignoli
pinole83218783pi_nole
rigor62714053rig_or_
rigors72813713rig_ors
sagamore1144353sagamore
score75526743s__core
segno64814743segno__
segnos73610443segno_s
seignior943313seignior_
seigniors1043333seigniors
seigniory1342423seigniory
seignorage1251703seignorage
seignories1144973seignories
senor53822803s_enor_
senora63216163s_enora
senores73218113s_enores
senors63620793s_enors
shore85432653s__hore
sienite7312713sienite
sigher103813703sigher_
sighers113712183sighers
sighter113412113sighter
sigloi737743siglo_i
siglos7311473siglo_s
sigmate10710143sigmate
sigmoid1146113sigmoid
sign55523053sign___
signa66114703sign__a
signages1037483signages
signal73711483sign_al
signaled1035393signaled
signaler945453signaler
signals8359163signals
signatory1344623signatory
signature1053763signature
signboard1343773signboard
signed83413753sign_ed
signees83510803signees
signet73621153sign_et
signeted1035973signeted
signets83311503signets
signify1444853signify
signing92713963signing
signiories1144303signiories
signorina1043963signorina
signpost1144163signpost
signs65516323sign__s
since75024173si_n_ce
sincere9310553sincere
sine46560623si_n__e
singe65731133si_n_ge
singer74227313singer_
singers83824703singers
single74520603si_ngle
sinker103620903si_nker
sinner64320603sinner_
sinners74019023sinners
sinopie948783si_nopie
sinter63625923si_nter
sire46150413si___re
snare54429983s__nare
snored74819543s__nored
snorer64316763s__norer
snores64324323s__nores
snort54833753s__nort
soigne74310033soign__e
soignee8279133soign_ee
sore47059533s___ore
spinor839943spinor_
spinors939423spinors
spinose937943spinose
splore81611303s_plore
spore75428593s__pore
store56333813s__tore
swore84920823s__wore
vigor92612423vig_or_
vigors102911483vig_ors
zingare1737143zingare

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.390458182.1
2DLD Change Limit1340271245.83022989.2
3Display Results1241240.0462695.7
 (SQL Overall)1786911246.26628517.6
 
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.